You are creating a SQL Server 2008 Integration Services (SSIS) package which is created
through utilizing local development environment for Company.com. You get data by package
which inserts it in the PROD database on the local SQL Server 2008 instance from a remote
server. You publish it to the MSDB database on the production server. Not only should you
make users who belong to a proper database role change and run the deployed package.
But also you should make sure that these users could not access other packages which are
published to the server. Which is the correct answer?
A.
You should allot the users to the db_system role.
B.
You should allot the users to the db_owner role.
C.
You should allot the users to a common database role in the default database.
D.
You should allot the users to a common database role in the MSDB database.