13.14 Specifying the falsification prevention facility

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

OperationFalsification prevented table
Deletion prevented duration specifiedDeletion prevented duration not specified
Insert (INSERT)YesYes
Retrieve (SELECT)YesYes
Update by column (UPDATE)Yes1Yes1
Update by row (UPDATE)NoNo
Delete (DELETE)Yes2No
Delete all rows (PURGE TABLE)NoNo
Data manipulation SQL other than the aboveYesYes
Legend:
Yes: Can be executed.
No: Cannot be executed.
1 Only updatable columns can be updated.
2 Only data that has passed the deletion prevented duration can be deleted. If no deletion prevented duration is specified, the table data cannot be deleted.
Applicability standards
The falsification prevention facility is recommended for use with tables when it is important to prevent the table data from accidental modification or unauthorized tampering.
Organization of this section
13.14.1 Specification
13.14.2 Restrictions
13.14.3 Changing a falsification-unprevented table to a falsification prevented table
13.14.4 Error operation