Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to drop database user Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 6:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 13, 2014 7:57 AM
Points: 3, Visits: 188
Hi,

We are unable to drop a database user with the following error "Msg 15284, Level 16, State 1, Line 1
The database principal has granted or denied permissions to objects in the database and cannot be dropped."

On checking the database permissions we have the following permissions assigned to the user

class class_desc major_id minor_id grantee_principal_id grantor_principal_id type permission_name state state_desc
17 SERVICE 65536 0 5 17 SN SEND G GRANT
17 SERVICE 65537 0 5 17 SN SEND G GRANT
17 SERVICE 65538 0 5 17 SN SEND G GRANT
17 SERVICE 65539 0 5 17 SN SEND G GRANT
17 SERVICE 65540 0 5 17 SN SEND G GRANT
17 SERVICE 65541 0 5 17 SN SEND G GRANT
17 SERVICE 65542 0 5 17 SN SEND G GRANT
17 SERVICE 65543 0 5 17 SN SEND G GRANT
17 SERVICE 65544 0 5 17 SN SEND G GRANT
17 SERVICE 65545 0 5 17 SN SEND G GRANT
17 SERVICE 65546 0 5 17 SN SEND G GRANT
17 SERVICE 65547 0 5 17 SN SEND G GRANT
17 SERVICE 65548 0 5 17 SN SEND G GRANT
17 SERVICE 65549 0 5 17 SN SEND G GRANT
17 SERVICE 65550 0 5 17 SN SEND G GRANT
17 SERVICE 65551 0 5 17 SN SEND G GRANT
17 SERVICE 65552 0 5 17 SN SEND G GRANT
17 SERVICE 65553 0 5 17 SN SEND G GRANT
17 SERVICE 65554 0 5 17 SN SEND G GRANT

Does anyone know how we can revoke the SEND permissions?

Thanks.
Post #1568416
Posted Thursday, May 8, 2014 8:39 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:09 AM
Points: 507, Visits: 1,867
Have you done (in master)

SELECT * from sys.database_principals where principal_id = 17

yet, to find the name of the grantor? Then you could revoke the permissions from them. (Sorry if I'm teaching you to suck eggs .)
Post #1568931
Posted Thursday, May 8, 2014 8:39 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:09 AM
Points: 507, Visits: 1,867
[dup]
Post #1568932
Posted Wednesday, June 18, 2014 4:24 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 420, Visits: 996
Was this message the result of a server trigger, has this been ruled out? To remove permissions, one would employ the REVOKE command.
Post #1583457
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse