July 15, 2008 at 10:11 am
Hi all,
I need expert advice.
I have a request from one of our user, who wants to
1. Create and Schedule jobs
2. View Job History
3. Execute Job, whenever required.
Our environment is on SQL Server 2005, and i dont want him to be granted Admin rights
Your help could be appricaited
DL
July 15, 2008 at 10:50 am
The SQLAgentUserRole might be just what you need. See BOL at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm
Greg
July 15, 2008 at 12:42 pm
I have written small web application to do just this. It is worth creating an application that you can control a bit better than giving someone access to the job agent and giving them Management Studio. You at least want to be able to control if they can delete backup jobs.
July 15, 2008 at 2:19 pm
SQL Agent database role members can only change or delete jobs they own.
Greg
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply