Click here to monitor SSC
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
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 309
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
SSC Eights!
SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)

Group: General Forum Members
Points: 940 Visits: 3518
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
SSC Eights!
SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)SSC Eights! (940 reputation)

Group: General Forum Members
Points: 940 Visits: 3518
[dup]
MMartin1
MMartin1
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1077 Visits: 2009
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