January 6, 2015 at 8:12 am
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???
January 6, 2015 at 10:36 am
Jpotucek (1/6/2015)
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???
Correction. This is SQL Server 2008 NOT 2012
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply