DB2 SQL-Error: -552
SQLState: 42504
Short Description: C E SQL CANNOT HAVE THE PRIVILEGE REVOKED BY BECAUSE THE REVOKEE DOES NOT POSSESS THE PRIVILEGE OR THE REVOKER DID NOT MAKE THE GRANT
The REVOKE statement was not successful for one of the following reasons: v Authid2 does not possess the privilege. v The revoker, authid1, did not explicitly grant the privilege to authid2. v Authid2 is the owner of the specified object. v When privilege is '***' the keyword ALL was used in the REVOKE statement, but authid2 did not possess any privilege to revoke. v When authid1 is ALL, the BY ALL clause was used in the REVOKE statement, but authid2 did not possess any privilege to revoke. An authorization ID can revoke only the privileges that it has explicitly granted to other authorization IDs, unless the authorization ID has SYSADM or SYSCTRL authority and specifies the BY clause. No authorization ID, not even SYSADM, can revoke 'privileges' on an object from the object owner. System action: The statement cannot be executed. No privileges were revoked from any authorization ID. Programmer response: Check the appropriate authorization catalog tables to verify that authid2 possesses the privilege to be revoked. Queries can be made with GRANTEE = authid2 and the privilege column not = blanks. Correct and reissue the REVOKE statement. If a user holding SYSADM or SYSCTRL authority receives this SQLCODE, the BY clause might have been omitted from the REVOKE statement.