logo  
Google
 

DB2 SQL-Error: -555

SQLState: 42502

Short Description: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF

An authorization ID 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. However, if SQLRULES(STD) is in effect or CURRENT RULES contains STD, REVOKE to self is allowed. System action: The statement cannot be executed. No privileges were revoked. Programmer response: Refer to Chapter 5 of DB2 SQL Reference for information about restrictions on the use of the REVOKE statement.

 <-  BACK TO INDEX