The falsification prevention facility provides a means for prohibiting all users, including the table owner, from updating table data. This facility protects important data from accidental modification or unauthorized tampering. Tables to which this facility has been applied are called falsification prevented tables. The following table lists operations that can be executed on falsification prevented tables.
Table 12-5 Operations permitted on falsification prevented tables
Operation | Falsification prevented table | |
---|---|---|
Deletion prevented duration specified | Deletion prevented duration not specified | |
Insert (INSERT) | Yes | Yes |
Retrieve (SELECT) | Yes | Yes |
Update by column (UPDATE) | Yes#1 | Yes#1 |
Update by row (UPDATE) | No | No |
Delete (DELETE) | Yes#2 | No |
Delete all rows (PURGE TABLE) | No | No |
Data manipulation SQL other than the above | Yes | Yes |