In this post, you’ll learn about the error message -555 an authorization id cannot revoke a privilege from itself in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-555 an authorization id cannot revoke a privilege from itself
Reason for the Error
An authorization ID has attempted to execute a REVOKE statement in which that ID itself appears as one of the entries in the list of authorization IDs to be revoked.An authorization ID cannot REVOKE its own privilege.
Solution
Take one of the following actions and reissue the REVOKE statement:
Remove the authorization ID that issues the REVOKE statement from the list of authorization IDs to be revoked.
Issue the REVOKE statement from a different authorization ID.
