SQLAgentUserRole - Security risk!

  • Anybody else notice that if you put a user in the fixed sqlagent roles, that it allows the to stop the sqlagent service? Anyone know how to prevent this?

  • Is that user a windows or sql user. If windows then you can remove full control privileges in te registry key to avoid him restarting.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Its a SQL login. I assume it would go either way, but my case happens to be a SQL login

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

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