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

Yes by default person B wont be able to see pkg, but Q is If person B wants to see than what action is required. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
November 20th, 2010 1:38pm

Yeah, the way question is asked is quite ambigious. And you'll find many question like that. Get used to it. For this question, when they say "What do you need to do to ensure that the package developers can see the packages?", what they really want to say is "What do you need to do to ensure that the package developers can see their respective packages?" Hope that helps :)Press CTRL-ALT-DEL now for an IQ test.
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2010 8:58pm

Yeah, the way question is asked is quite ambigious. And you'll find many question like that. Get used to it. For this question, when they say "What do you need to do to ensure that the package developers can see the packages?", what they really want to say is "What do you need to do to ensure that the package developers can see their respective packages?" Hope that helps :) Press CTRL-ALT-DEL now for an IQ test. Oh. The way I inerpreted it was. I am creating a package, what do i need to do to ensure that the other package developers can see this specific package that I am developing. I guess it makes sense using your interpretation.
November 21st, 2010 7:52am

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

Other recent topics Other recent topics