0

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?

2
  • 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
5

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.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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