KFAA31436-E

The aa....aa privilege cannot be revoked because RESTRICT is specified for the drop behavior. <SQLSTATE: 42K26>

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

• SELECT: SELECT privilege

• REFERENCES: REFERENCES privilege

• ACCESS: Access privilege

bb....bb: Reason why it cannot be revoked

• viewed table exists:

  There is a viewed table that was defined using the SELECT privilege whose revocation was attempted.

• referential constraints exist:

  There is a referential constraint that was defined using the REFERENCES privilege whose revocation was attempted.

• dependent privileges exist:

  The access privilege whose revocation was attempted has dependent privileges.

S:

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

Action:

Take one of the following corrective actions:

• Re-execute the SQL statement with CASCADE specified for the drop behavior.

• Take one of the following corrective actions, and then re-execute the SQL statement with RESTRICT specified for the drop behavior.

  • If bb....bb is viewed table exists

    Delete the viewed table defined using the SELECT privilege to be revoked.

  • If bb....bb is referential constraints exist

    Delete the referential constraint defined using the REFERENCES privilege to be revoked.

  • If bb....bb is dependent privileges exist

    Delete the dependent privileges of the access privilege to be revoked.