SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unable to drop database user


Unable to drop database user

Author
Message
Astorre
Astorre
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 350
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.
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6835 Visits: 4830
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 :-D.)
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6835 Visits: 4830
[dup]
MMartin1
MMartin1
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7157 Visits: 2033
Was this message the result of a server trigger, has this been ruled out? To remove permissions, one would employ the REVOKE command.

----------------------------------------------------
How to post forum questions to get the best help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search