ACCESS_POLICY
Provides information about existing access policies.
| Column Name | Data Type | Description |
|---|---|---|
| ACCESS_POLICY_OID |
INTEGER |
The unique identifier for the access policy. |
| TABLE_NAME |
VARCHAR |
Name of the table specified in the access policy. |
| IS_POLICY_ENABLED |
BOOLEAN |
Whether the access policy is enabled. |
| POLICY_TYPE |
VARCHAR |
The type of access policy assigned to the table:
|
| EXPRESSION |
VARCHAR |
The expression used when creating the access policy. |
| COLUMN_NAME |
VARCHAR |
The column to which the access policy is assigned. Row policies apply to all columns in the table. |
| TRUST_GRANTS | BOOLEAN | If true, GRANT statements override the access policy when determining whether a user can perform DML operations on the column or row. |