February 24, 2006 at 12:58 pm
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
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
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
also check if explicit denies where applied to those users or groups...
HTH
March 2, 2006 at 5:31 am
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