Give access to SQL Server Agent ONLY?

• hambo12

  SSC Journeyman

  Points: 87

  More actions

  April 16, 2013 at 12:15 am

  #292277

  Just wondering if it is possible to give someone SSMS access, however only allow them to run jobs within the SQL Server Agent and nothing else?

• rajeshsdba

  SSC Veteran

  Points: 210

  More actions

  April 16, 2013 at 2:24 am

  #1606733

  Hi ,

  Yes, you can give the permission only for sql agent.

  Login with SSMS with sa and creat a user.

  select the MSDB and seleect SQLAGENTOPERATORROLE, SQLAGENTREADERROLE.

  RAJESH SINGH

  DBA.

  HCL COMNET

  Rajesh Singh
  DBA(HCL Comnet)
  +91-0560888360