KFAA31436-E
The aa....aa privilege specified as "RESTRICT" cannot be revoked. (reason = bb....bb) (M+J+O)
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.
-
-