August 11, 2009 at 2:01 pm
i am trying to assign package roles to the user...i have different folders under msdb for different apps...i am looking for a way where i can restrict the user to one particular folder instead of giving access to all the packages inside msdb..like if if give dts_ltduser only the owner can run but i want the other user who belongs to the same group be able to run the package and also delete/upload...basically looking for a way tp restrict the users on a particular folder in msdb..please advise..thanks
August 11, 2009 at 2:20 pm
I'm pretty sure you can't do what you want using the SSIS roles. You'd have better luck storing the packages in file system folders and restricting access to those.
Greg
August 11, 2009 at 2:33 pm
thanks Greg...but the only problem with filesystem is like the packages need to go under certain security policy like "rely on server storage for access"..i dnt think i can make use of this option when i use to store package in filesystem
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply