You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package on a development server named ABCDB03. The SSIS package obtains data that will be inserted in a database named CKProducts from a remote SQL Server 2008 database server named TESKING-DB01. The data is published to the MSDB database on a production server named ABC-DB02. You should make sure that only users belonging to the appropriate database role are able to change and run the package. What should you do?
1)You should assign the users to the db_system role. 2)You should assign the users to a pre-defined security role. 3)You should assign the users to a common database role in the default database. 4)You should assign the users to a common database role in the MSDB database. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at firstname.lastname@example.org
By using the service of this site, I agree that I will serve wholeheartedly
and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
I have a firm believe in the notion that knowledge should be open source and
helping the needy and deserving part of society will always be my motto.
Knowledge is the power, Dont miss any paper, Subscribe to us