Add them to the TargetServer role in the MSDB database and they should be able to run jobs without sysadmin

--------------------------
Sent from my BlackBerry Wireless Handheld


-----Original Message-----
From: Katula Kristen <mssqldba-ezmlmshield-x81397414.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Tue Oct 31 05:56:58 2006
Subject: Permissions for account running SQL Server Agent

We have DTS Packages which run as a scheduled job on the SQL Server.
Due to SOX, we are trying to avoid granting "Administrator" permissions
to users on the server, wherever possible.



Can anyone tell me what minimum server permissions are needed to be a
user to successfully run the SQL Server Agent Service which will kick
off this job? Also, does the same account need to be set up as
"sysadmin" in the database---or would it be feasible to set the user
with lesser permissions, such as "dbowner"? Obviously, if our Network
Group has access to the password to the account which can access the
server, and this account also has permissions to the database, we'd like
to limit the Database access to avoid separation of duties conflicts.



Thanks in advance for your suggestions,

Kristen



Kristen L. Katula

Database Administrator

Volvo Financial Services North America

--------------------------------------------------------

This message (including any attachments) contains confidential information intended for a specific individual and purpose and is protected by law. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message (and any attachments) from your system. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the exclusive and confidential use of the addressee. Any other distribution, use, reproduction or alteration of the information contained in this electronic message, by the addressee or by any other recipient, without the prior written consent of the sender is strictly prohibited. If you have received this electronic message in error, please notify the sender.


MS Sql Server LazyDBA home page