Post reply

Built in Server Roles Locked Out

  • February 24, 2006 at 12:58 pm

    #96662

    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.

  • February 24, 2006 at 3:35 pm

    #623335

    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.

  • February 27, 2006 at 5:21 am

    #623419

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

  • March 2, 2006 at 12:36 am

    #624202

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

     

    HTH

  • March 2, 2006 at 5:31 am

    #624253

    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