Update Permission Property
Description
Setting Update Permission to No performs the
following three actions:
- Sets the Update If Null property to No.
- Sets the Update Allowed property to No.
- Specifies that this column should not be included in any UPDATE statements
issued by Oracle Forms by removing that column from the SET clause of the
UPDATE statements.
Setting Update Permission to Yes performs
does the inverse of (2), but not of (1); that is, it adds the item to UPDATE
statements issued by Forms, but it has no effect on the Update Allowed and Update
If Null properties.
Also, UPDATE statements are affected only if the Enforce
Column Security property of the block is set to TRUE.
Applies to all items except buttons and chart items
Set programmatically
Refer to Built-in
GET ITEM PROPERTY
SET ITEM PROPERTY
Yes
Required/Optional optional
Usage Notes
- Update Permission allows form developers to implement their own security
mechanism, overriding the Oracle Forms default Enforce Column Security
property. This property is included primarily for applications that will run
against non-ORACLE data sources. Use Update Permission when you want to exclude
certain columns from any UPDATE statements: for example, when using an On-Column-Security
trigger to implement a custom security scheme.
Related topic
Enforce Column Security property