Unable to drop database user

  • 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.

  • [dup]

  • 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.)

  • 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