KFAA30555-E

A user cannot revoke any privilege aa....aa that the user has granted to himself or herself. <SQLSTATE: 42K05>

aa....aa: Privilege that cannot be revoked

• DBA: DBA privilege

• CONNECT: CONNECT privilege

• AUDIT ADMIN: Audit admin privilege

If multiple privileges were specified in the REVOKE statement, only one of those privileges is displayed.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

• If this message is output when you attempt to revoke the DBA or CONNECT privilege

  You cannot revoke the DBA or CONNECT privilege granted to you. Ask another HADB user who has the DBA privilege to revoke your DBA or CONNECT privilege.

• If this message is output when you attempt to revoke the audit admin privilege

  If you are the only HADB user who has both the audit admin privilege and CONNECT privilege, you cannot revoke your audit admin privilege. Therefore, if you want to change the HADB user who has the audit admin privilege, you must first grant the audit admin privilege and CONNECT privilege to another HADB user. Then, revoke your audit admin privilege. An HADB user who has the DBA privilege must grant the audit admin privilege and CONNECT privilege.

  If this message is output when you attempt to revoke your audit admin privilege in order to stop operation of the audit trail facility, follow the procedure in Stopping use of the audit trail facility in the HADB Setup and Operation Guide.