Start of change

-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 or history table.
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

End of change