-20472 PERMISSION OR MASK object-name CANNOT BE ALTERED AS SPECIFIED. REASON CODE reason-code.
Explanation
The ALTER MASK or ALTER PERMISSION statement could not be processed.
- object-name
- The name of the object.
- reason-code
- The reason for the message or SQL code,
indicated by one of the following
values:
- 1
- A default row permission cannot be altered.
- 2
- ENABLE cannot be specified because the object is invalid after a previous attempt to regenerate it was unsuccessful.
System action
The statement cannot be processed.
Programmer response
Specify the name of a row permission that can be changed. For the invalid state, disable the row permission or column mask, then drop and re-create it with the modified definition.
SQLSTATE
428H9