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 12-5 lists the operations that are permitted 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)	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

Legend:

Yes: Can be executed.

No: Cannot be executed.

¹ Only updatable columns can be updated.

² 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

12.14.1 Specification

12.14.2 Restrictions

12.14.3 Changing a falsification-unprevented table to a falsification prevented table

12.14.4 Error operation