-20469 ROW OR COLUMN ACCESS CONTROL CANNOT BE ACTIVATED FOR TABLE table-name FOR REASON reason-code. object-type object-name IS NOT IN A VALID STATE FOR ACTIVATING ACCESS CONTROL FOR THIS TABLE
Explanation
Row access control cannot be activated explicitly or implicitly, or column access control cannot be activated explicitly for the table.
- table-name
- The name of the table.
- reason-code
- The reason for the message or SQL code,
indicated by one of the following
values:
- 36
- The object-name view is defined on the table and the view is defined with the WITH CHECK OPTION clause.
- 37
- The object-name trigger is defined for the table and the trigger is not defined as secure.
- 38
- A view is defined on the table, the object-name trigger is defined for that view, and the trigger is not defined as secure.
- 39
- The table is directly or indirectly referenced in the definition of a materialized query table.
- 40
- The table is a created temporary table.
- 41
- The table has a row permission or a column mask that is not valid because a previous attempt to regenerate it was unsuccessful.
- 42
- The table cannot be activated for the row access control because the table contains a security label column.
- 43
- The table cannot be activated for the row access control or column access control, because the table is a system-period temporal table, history table, archive-enabled table, or archive table.
- 79
- The table cannot be activated for the row access control or column access control because the table has been granted federated access to another Db2 for z/OS® subsystem in IBM® Db2 Analytics Accelerator.
- object-type
- The type of object.
- object-name
- The name of the object.
System action
The statement cannot be processed.
Programmer response
Correct the error and reissue the statement to activate row or column access control for the table. For the invalid state, disable the row permission or column mask. Then, drop and re-create it with the modified definition.
SQLSTATE
55019