Post reply

Minimum Rights for NT user to run SQL maintenance

  • July 17, 2008 at 2:04 am

    #188199

    I need to create an NT user account for running maintenance jobs, but i want to give only the minimum rights for the user access. I don't want to use the localsystem or sa as I'm running Windows Auth on the server. Please can you give me any idea's asap.

    Thanks

    Keith

  • July 17, 2008 at 2:30 am

    #844203

    I would just create a basic NT account that has ad rights and then add them to the sql server users with the rights of process administrators role, if they do not need to do anything apart from run jobs then this is the role to use.

    Regards,

    Terry

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

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