Post reply

jobs

  • October 16, 2010 at 10:54 pm

    #228078

    A user is there I want to assign permission or role to that user like he is able to create job, run job duties only, then how will give or assign role to this particular user?

  • October 17, 2010 at 3:28 am

    #1238089

    It depends.

    Sounds like an interview question (at least in combination with your other question at the very same time)


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • October 18, 2010 at 5:11 am

    #1238324

    Hi,

    MSDB (System Database) has role like:

    SQLAgentOperatorRole

    SQLAgentReaderRole

    SQLAgentUserRole

    You can assin a role to your user to perform SQL Agent Tasks.

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

    Ram
    MSSQL DBA

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

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