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.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 access to legacy DTS packages

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
Go to Top of Page

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2015-01-07 : 02:25:05
http://www.sqlservercentral.com/Forums/Topic451364-146-1.aspx

Javeed Ahmed
https://www.linkedin.com/pub/javeed-ahmed/25/5b/95
Go to Top of Page
   

- Advertisement -