ssisltduser - mcts trainging question
Hi, Book states that
ssisltduser can view users packages in contrast ssisoperator can view all packages implication being ltduser can only view his own packages and not anyone elses.
There is a question in the practise test
You are deploying several SQL Server Integration Services (SSIS) packages.
You are using the deployment utility to deploy the packages to the production SQL server in the msdb database.
What do you need to do to ensure that the package developers can see the packages?
The correct answer is
Add the package developers' msdb role, db_ssisltduser, in the msdb database.
I dont understand how this answer can be correct based on the definition given earlier. If person A develops a package then person B should not be able to see it if person B is a ltduser, I would have thought ssisoperator would have been the correct answer
as they can view all packages.
I know I am wrong. Why am I wrong?
November 20th, 2010 3:50am
What do you need to do to ensure that the package developers can see the packages?
In this sentence only access needs to set for package developers, not others. so db_ssisltduser will access only package developers.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2010 3:58am