COLUMN_AUTH_INDICATOR Function

The COLUMN_AUTH_INDICATOR function checks whether the specified table column is authorized on a particular table row. If the current application user is authorized by data security policies to access the column value of the current row, or if the column is not protected by any data security policies, then it returns 1. If the application user is not authorized, it returns 0.

Syntax

COLUMN_AUTH_INDICATOR(col)
RETURN BOOLEAN;

Parameters

Parameter	Description
col	A column in a table or view. This parameter does not accept object type columns or expressions.

Example

SELECT po_number, project_id, region,
 DECODE(COLUMN_AUTH_INDICATOR(price), 0, 'xxxxxx', 1, price) price
 FROM purchaseorder
 WHERE po_number
 BETWEEN 10000 and 10003;

See Also:

• “Applying Additional Application Privileges to a Column” for more detailed example of using the COLUMN_AUTH_INDICATOR function

• Oracle Database Real Application Security Data Dictionary Views for information about the ALL_ATTRIBUTE_SECS, DBA_ATTRIBUTE_SECS, and USER_ATTRIBUTE_SECS data dictionary views, which list existing tables that use column level security