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 users can view, execute, and delete their own packages.
What should you do?
1)Assign the users to the db_ssisoperator role. 2)Assign the users to the db_ssisltduser role. 3)Assign the users to a custom database role in the PROD database. 4)Assign the users to the db_ssisadmin role. 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