Purpose
The DBA_POLICIES view displays the access control strategies that can be created on a table.
Note
This view is introduced since OceanBase Database V4.1.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OBJECT_OWNER | VARCHAR2(128) | YES | The owner of the object controlled by the strategy. |
| OBJECT_NAME | VARCHAR2(128) | YES | The name of the object controlled by the strategy. |
| POLICY_GROUP | VARCHAR2(128) | NO | The name of the strategy group. |
| POICY_NAME | VARCHAR2(128) | NO | The name of the strategy. |
| PF_OWNER | VARCHAR2(128) | NO | The owner of the strategy function. |
| PACKAGE | VARCHAR2(128) | NO | The name of the package where the strategy function is located. |
| FUNCTION | VARCHAR2(128) | NO | The name of the strategy function. |
| SEL | VARCHAR2(3) | NO | Indicates whether the SELECT operation on the object is affected. Valid values: YES and NO. |
| INS | VARCHAR2(3) | NO | Indicates whether the INSERT operation on the object is affected. Valid values: YES and NO. |
| UPD | VARCHAR2(3) | NO | Indicates whether the UPDATE operation on the object is affected. Valid values: YES and NO. |
| DEL | VARCHAR2(3) | NO | Indicates whether the DELETE operation on the object is affected. Valid values: YES and NO. |
| IDX | VARCHAR2(3) | NO | Indicates whether the INDEX operation on the object is affected. Valid values: YES and NO. |
| CHK_OPTION | VARCHAR2(3) | NO | Indicates whether check on the updated value for the INSERT or UPDATE operation is affected. Valid values: YES and NO. |
| ENABLE | VARCHAR2(3) | NO | Indicates whether the strategy takes effect. Valid values: YES and NO. |
| STATIC_POLICY | VARCHAR2(3) | NO | Indicates whether the strategy is a static one. Valid values: YES and NO. |
| POLICY_TYPE | VARCHAR2(24) | NO | The strategy type. Valid values:
|
| LONG_PREDICATE | VARCHAR2(3) | NO | Indicates whether the predicate returned by the strategy function will exceed 4,000 bytes in length. |
| COMMON | VARCHAR2(3) | NO | This column is used only for the purpose of compatibility, and the value is fixed at NO. |
| INHERITED | VARCHAR2(3) | NO | This column is used only for the purpose of compatibility, and the value is fixed at NO. |