Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm on SQL SERVER 2008,

I want to enable the SQL Agent for a particular user, who has only read access to the database. I don't want to give sysadmin role?

Is there any way, I can do this?

share|improve this question
    
What do you mean by "enable SQL Agent for a user"? Allow them to create jobs? Allow them to execute jobs but not create them? Read access to which database? –  Jon Seigel Sep 17 '13 at 22:51
    
Yes, Allow them to create and execute the jobs. The user has read access to the specific db created in the server –  Viji Sep 17 '13 at 22:54

1 Answer 1

up vote 5 down vote accepted

from BOL :

To configure a user to create or execute Microsoft SQL Server Agent jobs, you must first add an existing SQL Server login or msdb role to one of the following SQL Server Agent fixed database roles in the msdb database: SQLAgentUserRole, SQLAgentReaderRole, or SQLAgentOperatorRole.

share|improve this answer
    
Thanks for your response. –  Viji Sep 18 '13 at 18:51
    
technet.microsoft.com/en-us/library/ms187901.aspx , it explains how to add the SQLAgent roles to the non-admin user –  Viji Sep 18 '13 at 18:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.