var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: access to legacy DTS packages
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
Originally Posted by itsonlyme44
In theory, theory and practice are identical. In practice, theory and practice are unrelated.