Post reply

Security for creating jobs in SQL 2005

  • June 13, 2008 at 3:05 am

    #187884

    Hi Guys,

    Do you perhaps know what kind access I need to give a user to create jobs on SQL 2005?

    I don't want to give them sysadmin rights.

    Please help!!

    IC

  • June 13, 2008 at 3:39 am

    #828318

    BOL:

    To run this stored procedure (sp_add_job), users must be a member of the sysadmin fixed server role, or be granted one of the following SQL Server Agent fixed database roles, which reside in the msdb database:

    SQLAgentUserRole

    SQLAgentReaderRole

    SQLAgentOperatorRole

  • June 13, 2008 at 4:02 am

    #828332

    thanx Suresh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply