ACCESS_POLICY

Provides information about access policies associated with specific tables.

Column Name Data Type Description
ACCESS_POLICY_OID

INTEGER

A unique identifier for the access policy.
TABLE_NAME

VARCHAR

Name of the table with which the access policy is assigned.

IS_POLICY_ENABLED

BOOLEAN

Indicates whether or not you have enabled the access policy.

POLICY_TYPE

VARCHAR

The type of access policy assigned to the table, valid values are:

  • Column Policy
  • Row Policy
EXPRESSION

VARCHAR

The expression used when creating the access policy.

TRIGGERED_BY

VARCHAR

The SQL statement that triggers the access policy.

COLUMN_NAME

VARCHAR

The column to which the access policy is assigned.