You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Integration Services (SSIS) for the company.
To meet the business requirement, SSIS and the local development environment are used to design a package.
The package has the data extracted from a remote server. Besides, it has the data inserted in the PROD database on the local SQL Server 2008 instance.
Then you have the package deployed to the MSDB database on the production server.
Now you get an order from your company CIO, according to his requirement, you should make sure that the deployed package can be modified and executed only when users play an appropriate database role.
Besides, you have to make sure that other deployed packages on the server can not be accessed by these users.
What action should you perform to achieve the goals above?
A.
A custom database role in the PROD database should be assigned to the users
B.
A custom database role in the MSDB database should be assigned to the users
C.
The db_ssisltduser role in the PROD database should be assigned to the users
D.
The db_ssisoperator role should be assigned to the users
E.
The db_ssisltduser role should be assigned to the users