Post reply

privileges to a login

  • January 16, 2004 at 9:36 am

    #84354

    Hi,

    What is the bare minimum rights required only to run a sql server job?
     
    Is there any built in server role or I need to create it.
    I have just created a login that runs a job to take backups I need to give only this much access to the new login, how to do that?
     
    Thanks & Regards,
    Manoj

     

  • January 16, 2004 at 11:05 am

    #490493

    no built in roles. You need to be the owner if you're not a sysadmin, I believe.

  • January 19, 2004 at 5:03 am

    #490633

    OK Steve,

    What rights I need to give to login e.g. 'user1' in order to let user1 run the job only which is owned by user1, and to make sure user1 can't do anything else.

    What minimum rights are required?

    Manoj.

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

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