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. Table 13-5 lists the operations that are permitted on falsification prevented tables.
Table 13-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) | Yes1 | Yes1 |
Update by row (UPDATE) | No | No |
Delete (DELETE) | Yes2 | No |
Delete all rows (PURGE TABLE) | No | No |
Data manipulation SQL other than the above | Yes | Yes |