Post reply

Permission for SQL Jobs

  • January 11, 2008 at 9:08 am

    #154058

    I want to give access to one of the group who can shcedule SQL jobs , Run jobs or Delete job or Add New jobs what SQL permission I need to do this in SQL 2005?

    The DBO permission will do that?

    Nita

  • January 11, 2008 at 9:16 am

    #767181

    Only members of the sysadmin fixed server role can create jobs. That would mean that the user that has been granted access to create Jobs can do anything on the database.

    -Roy

  • January 11, 2008 at 9:19 am

    #767186

    I don't want to give sysadmin access? any alternate

  • January 11, 2008 at 9:20 am

    #767188

    Do you mean one group or one user in a group? Whichever user it is needs to be added to the database role SQLAgentOperatorRole in the msdb database. If you want the user to be able to modify and delete jobs and schedules that they don't own then they will need to be a sysadmin.

    See MSDN for a full explanation:

    http://msdn2.microsoft.com/en-us/library/ms188283.aspx

  • January 11, 2008 at 9:24 am

    #767191

    Read about the SQL Server Agent fixed database roles i.e. SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole in BOL and see which one fits your needs. Members of the roles can create and manage roles without having other admin privileges.

    Greg

    Greg

  • January 11, 2008 at 9:34 am

    #767202

    Excellent I am running as a group and that solve my problem..I tested and its working

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

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