Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
The EXECUTE permission was denied on the object sp_enum_dtspackages
07 January,2015 by Tom Collins
Granting permissions on SQL Server , to view legacy DTS packages requires EXECUTE permissions to various stored procedures on the msdb system database.
The easiest way to implement , is to create a database role including the permissions. Add the SQL Server login to the database role.
The added benefit of using database roles is it complies with standard SQL Server security policies. Most standard security policies advocate the usage of database roles versus using object level permissions. Read more on How to manage the IS_GRANTABLE security risk
Stored procedures required to view legacy DTS packages
Add EXECUTE permissions to these stored procedures in msdb . The login should now be able to view the relevant DTS packages.
sp_enum_dtspackagelog
sp_enum_dtspackages
sp_enum_dtssteplog
sp_enum_dtstasklog
sp_get_dtspackage
sp_get_dtsversion
sp_drop_dtspackage
sp_add_dtspackage
Read More on DTS packages
View DTS packages with Powershell – DTS to SSIS planning - SQL ...
SQL Server - Viewing legacy DTS packages in SSMS - SQL Server ...
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |