January 12, 2008 at 7:32 am
Hi All,
I would like to give a couple of users access to be able to stop and start replication jobs (both merge and transactional) without having to give them sysadmin rights. Is this possible? They do not require any other access to the server/databases apart from this.
Regards
John
January 13, 2008 at 3:14 pm
Check out SQL Server Agent roles in BOL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
January 14, 2008 at 7:08 am
Thanks for the reply Scott. I have taken a look at these roles and although the operatorRole gives the users the required privilages it gives them more access than i was wanting to give out (notably setting up and running jobs, which i dont want these guys to do)
I have tried giving them execute access to sp_start_job and sp_stop_job (stupid i know after what i said above, but unless they work out they have that access and run it through a query im not that fussed) so they could stop and start the replication jobs but this failed and said the jobid didnt exist.
Ill keep on looking, im sure a couple more SP's are out there that will do it for me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply