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.
| Author |
Topic |
|
oitsubob
Yak Posting Veteran
70 Posts |
 Posted - 2006-02-07 : 20:09:25
|
| Hey, quick question for you security guru's. Just trying to figure out what role a user would need to be in to schedule their DTS packages.Currently, we have our core DBA's that are sysadmins and then we have other users who are dbo's for their respective databases. Some of them we trust enough to schedule their own DTS packages, but I'm not sure what role to place them in to be able to do that.Any ideas?Thanks,Bob |
|
|
oitsubob
Yak Posting Veteran
70 Posts |
Posted - 2006-02-08 : 00:28:13
|
So I did some more research tonight and found an article [1] that says you can control this functionality by granting/denying execute permission on a couple stored proc's in the msdb db. quote:
You can also schedule execution of DTS packages using SQL Server Agent jobs. This ability is granted by default to the public group, based on permissions to execute sp_add_job and sp_add_jobschedule stored procedures in the MSDB database (this applies to all SQL Server Agent jobs, not just the ones that invoke DTS packages).
Strangely, public does have execute permissions to these procs on our box, yet our users seem not to be able to schedule packages.Hmmmm...again, I'm at a loss. Any suggestions?Thanks,Bob[1] http://www.databasejournal.com/features/mssql/article.php/3404791 |
 |
|
|
|
|
|
Permissions: Scheduling DTS Packages