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 |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2015-01-06 : 10:14:49
|
| I am attempting to grant access to a user (in DEV) to some legacy DTS packages that I have set up in a SQL Server 2012 Instance. He can see the packages but is getting is getting the following error attempting to open the package: The EXECUTE permission was denied on the object sp_enum_dtspackages, database msdb, schema dbo. (Microsoft.SqlServer.DtsObjectExplorerUI)As Sysadmin, I am able to open the packages. What permissions to I need to grant to this user so that they can open these packages as well??? |
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2015-01-06 : 12:35:23
|
| correction, this is sql server 2008 not 2012 |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2015-01-07 : 02:25:05
|
| http://www.sqlservercentral.com/Forums/Topic451364-146-1.aspxJaveed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
|
|
|
|
|
|
access to legacy DTS packages