HomeDB2DB2 Error Code – -555 an authorization id cannot revoke a privilege from itself

DB2 Error Code – -555 an authorization id cannot revoke a privilege from itself

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.

Share:

Leave a Reply

You May Also Like

In this post, you’ll learn about the error message -952 processing was interrupted by a cancel request from a client...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -927 the langrage interface was called when the connecting environment was...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -926 rollback not valid in ims/vs or cics environment in the...
  • DB2
  • November 21, 2022