Table: ALL_POLICIES
All policies for objects if the user has system privileges or owns the objects
| Column Name | Description |
|---|---|
| CHK_OPTION | Is check option enforced for this policy? |
| DEL | If YES, policy is applied to delete on the object |
| ENABLE | Is this policy is enabled? |
| FUNCTION | Name of the policy function |
| INS | If YES, policy is applied to insert on the object |
| OBJECT_NAME | Name of the synonym, table, or view |
| OBJECT_OWNER | Owner of the synonym, table, or view |
| PACKAGE | Name of the package containing the policy function |
| PF_OWNER | Owner of the policy function |
| POLICY_GROUP | |
| POLICY_NAME | Name of the policy |
| SEL | If YES, policy is applied to query on the object |
| STATIC_POLICY | Is this policy is static? |
| UPD | If YES, policy is applied to update on the object |