You design a package by using SQL Server 2008 Integration Services (SSIS). The package
is designed by using your local development environment.
The package extracts data from a remote server and inserts it in the PROD database on the
local SQL Server 2008 instance. You deploy the package to the MSDB database on the
production server.
You need to ensure that only users that belong to an appropriate database role can modify
and execute the deployed package. You also need to ensure that these users cannot access
other packages that are deployed to the server.
What should you do?
A.
Assign the users to the db_ssisoperator role.
B.
Assign the users to the db_ssisltduser role.
C.
Assign the users to a custom database role in the PROD database.
D.
Assign the users to a custom database role in the MSDB database.