Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2007-07-23 : 19:31:05
|
| All,Is there any standard roles available to execute the system stored procedures in MSDB? This question is because of the below error, which I got when I tried to Import a SSIS Package to Sql Server. While the error in itself is very clear, I wonder if this is due to the default permissions in Sql Server? TITLE: Import Package------------------------------The EXECUTE permission was denied on the object 'sp_dts_listpackages', database 'msdb', schema 'dbo'. (Microsoft SQL Native Client)------------------------------ADDITIONAL INFORMATION:The EXECUTE permission was denied on the object 'sp_dts_listpackages', database 'msdb', schema 'dbo'. (Microsoft SQL Native Client)To put it very simple, what all permissions will I need in MSDB if I have to import/work/execute SSIS packages inside Sql Server.ThanksKarunakaran |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-24 : 14:01:30
|
| Take look at 'sql server agent fixed database roles' in books online, may need grant permission on certain sps. |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2007-07-24 : 15:39:56
|
| Yeah, thats what we did. The DBA gave permission for the role of SQLAgentUser, that solved it. ThanksKarunakaran |
|
|
|
|
|
|
Permissions on MSDB