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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics