Built in Server Roles Locked Out

  • How would one go about preventing SQL Server 2000 built in server roles from working as documented? I am trying to give a specific user 'processadmin', but they still can't KILL a SQL process. I can't seem to give this ability to anyone without giving them the SysAdmin role, which is too much.

  • did you run sp_srvrolepermission  'processadmin' and make sure processadmin has 'kill' rights? I do not think you can take away rights from fixed server roles.

  • Further investigation reveals that the rights exist via Query Analyzer, but the options are grayed out on Enterprise Manager.

  • also check if explicit denies where applied to those users or groups...

     

    HTH

  • No explicit DENYs found.

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

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