April 29, 2009 at 2:24 pm
i have a user who needs access to legacy dts packages..on default instance i give the db_dtsuser role and db_reader role on msdb and the user is able to see,edit and save DTS packages...but on the same server for named instance when i give the same access to the msdb as in default , user can see DTS but throws following error;
The EXECUTE permission was denied on the object 'sp_enum_dtspackages', database 'msdb', schema 'dbo'.
when i explicitly give execute permission on msdb it works..just curious to know whats the difference in msdb between named and default instace or is it a bug in sql2005,,thanks,,
April 30, 2009 at 4:00 pm
Maybe the user was granted execute rights in the default instance's msdb, just not obvious to you that this was done? Could have gotten this via role membership, OS group membership, etc. I would find this much more plausible than notion that SQL sets up different default msdb rights on a default instance and a named instance.
May 1, 2009 at 7:42 am
thanks mike i checked..on default the user does not have any explicit permissions..all the user has it db_reader..thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply