June 7, 2005 at 11:29 pm
I created a DTS package under EM that works fine for me but when a developer tried to execute it under EM it said he lacked permission to run it.
What permissions, generally, are required to run a package under EM? (There's no doubt that if the package does a SELECT from a table the developer needs SELECT permissions; I wonder if permissons beyond that type of level are required.)
TIA,
Bill
June 9, 2005 at 5:43 am
After reading this post you got me thinking. I was near certain that the packages had no restrictions in them and there was no assocaited db role to execute. I found this article which seems to substantiate that. Hope it helps you out. In any case, it make some interesting reading.
http://www.databasejournal.com/features/mssql/article.php/3404791
June 9, 2005 at 12:19 pm
Bill,
Make sure that the Public role has permission to execute the "DTS" stored procedures in MSDB and that guest is a member of Public.
Greg
Greg
June 9, 2005 at 2:01 pm
Greg,
Can you clarify which stored procs in MSDB are DTS related?
TIA,
Bill
June 9, 2005 at 3:41 pm
When I thought about this a little more, it occured to me that I may have given you a bum steer, Bill.
I don't think the stored procedures actually have anything to do with executing a package, though they can be used to restrict a user's ability to save packages and to see them.
What message displays when the developer trys to execute the package.
Btw, the stored procedures in msdb have "dts" as part of the name. You can list them with this query:
select name, id from sysobjects where xtype = 'P' and name like '%dts%'
Greg
Greg
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply