May 7, 2014 at 6:35 am
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
classclass_descmajor_idminor_idgrantee_principal_idgrantor_principal_idtypepermission_namestatestate_desc
17SERVICE655360517SN SENDGGRANT
17SERVICE655370517SN SENDGGRANT
17SERVICE655380517SN SENDGGRANT
17SERVICE655390517SN SENDGGRANT
17SERVICE655400517SN SENDGGRANT
17SERVICE655410517SN SENDGGRANT
17SERVICE655420517SN SENDGGRANT
17SERVICE655430517SN SENDGGRANT
17SERVICE655440517SN SENDGGRANT
17SERVICE655450517SN SENDGGRANT
17SERVICE655460517SN SENDGGRANT
17SERVICE655470517SN SENDGGRANT
17SERVICE655480517SN SENDGGRANT
17SERVICE655490517SN SENDGGRANT
17SERVICE655500517SN SENDGGRANT
17SERVICE655510517SN SENDGGRANT
17SERVICE655520517SN SENDGGRANT
17SERVICE655530517SN SENDGGRANT
17SERVICE655540517SN SENDGGRANT
Does anyone know how we can revoke the SEND permissions?
Thanks.
May 8, 2014 at 8:39 am
[dup]
May 8, 2014 at 8:39 am
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.)
June 18, 2014 at 4:24 pm
Was this message the result of a server trigger, has this been ruled out? To remove permissions, one would employ the REVOKE command.
----------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply