April 26, 2002 at 12:54 pm
I have several SQL 2000 servers. On these severs there are multiple small databases that are for purchased apps. I am the central admin, but some of these databases have their own dba. These DBAs have their own DTS jobs. How can give these DBAs correct persmissions to create and schedule their DTS packages and have access to the SQL Agent jobs without making them system admins?
Thanks in advance,
April 29, 2002 at 11:36 am
The only permissions that I know of for DTS packages are those that are internal to the packages themselves (owner and user passwords), and permissions in the msdb database, which is where they are stored if you save them to SQL Server. You'll have to determine how to use this security to best serve your needs.
James C Loesch
James C Loesch
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply