KFAA30577-E

The schema definition privilege cannot be deleted because the HADB user assigned the authorization identifier specified in the REVOKE statement owns the schema. <SQLSTATE: 42K10>

aa....aa:

Authorization identifier specified in the REVOKE statement

S:

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

Action:

The REVOKE statement resulted in an error because the HADB user whose schema definition privilege was to be deleted owns the schema. Check if the schemas, tables, and indexes owned by the HADB user having the specified authorization identifier can be deleted.

If the tables owned by the HADB user are deleted by executing the REVOKE statement, the viewed tables and foreign keys of other schemas are affected as described below.

• Viewed tables (viewed tables of other schemas) that depend on a table deleted by executing the REVOKE statement are deleted (or invalidated).

• Foreign keys (foreign keys of other schemas) whose referenced table is deleted by executing the REVOKE statement are also deleted.

If there is no problem with the above influence, execute the REVOKE statement with CASCADE specified for drop behavior or without specifying the drop behavior. For details about the drop behavior specification, see Revoking user privileges, schema operation privileges, and audit privileges in the manual HADB SQL Reference.