Start of change

-20479   THE SOURCE TABLE table-name CANNOT BE ALTERED AS SPECIFIED BECAUSE THE TABLE IS INVOLVED IN ROW OR COLUMN ACCESS CONTROLS. REASON CODE reason-code.

Explanation

An unsuccessful attempt was made to alter or rename a table that is involved in row or column access controls.

table-name
The name of the table.
reason-code
The reason for the message or SQL code, indicated by one of the following values:
1
The table is referenced in one or more column mask or row permission definitions.
2
A column in the table is referenced in one or more column mask or row permission definitions.

System action

The statement cannot be processed.

User response

Correct the syntax, and reissue the statement.

SQLSTATE

42917

End of change