Re: Granting Access to Modify jobs

On Feb 14, 1:47 pm, Don <D...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
How do you grant a user access to modify SQL Server jobs without granting
them full access to the Server. I want them to have access to certain
databases and also have the ability to modiy/create jobs.

They will have to be a Login on the Server, a User in each database
and have some permission in msdb.

See SQL Server 2005 Books Online topics:

Selecting an Account for the SQL Server Agent Service - http://
msdn2.microsoft.com/en-us/library/ms191543.aspx
Implementing SQL Server Agent Security - http://msdn2.microsoft.com/en-
us/library/ms190926.aspx
Security for SQL Server Agent Administration - http://
msdn2.microsoft.com/en-us/library/ms190978.aspx
SQL Server Agent Fixed Database Roles - http://msdn2.microsoft.com/en-
us/library/ms188283.aspx




.

Relevant Pages

  • SQL Agent Service will not start
    ... In the Recovery model dropdown change the model ... Right click on the database select All Tasks, ... Change the recovery model back to it was before. ... Under management Right click on SQL Server Agent ...
    (microsoft.public.sqlserver.server)
  • Re: distribution database having problems???
    ... Stop the sql server agent on the publisher, ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Service Account
    ... it was recommended to use DBCC OPENTRAN etc - is it the ... although you could try backing up the database, ... server service and the sql server agent service use the ...
    (microsoft.public.sqlserver.replication)
  • SQL Express 2005 automatic backup
    ... I have been told that there was no sql server agent with sql express 2005. ... Does some one know how to make a automatic backup (for example every days at ... PM when no one is working on the database? ... Marc Allard ...
    (microsoft.public.sqlserver.msde)