USER_POLICIES v16
The USER_POLICIES view provides information on policies where the schema containing the object on which the policy applies has the same name as the current session user. This view is accessible only to superusers.
| Name | Type | Description |
|---|---|---|
schema_name | TEXT | Name of the schema in which the object resides. |
object_name | TEXT | Name of the object on which the policy applies. |
policy_group | TEXT | Name of the policy group. Included only for compatibility. Always set to an empty string. |
policy_name | TEXT | Name of the policy. |
pf_owner | TEXT | Name of the schema containing the policy function or the schema containing the package that contains the policy function. |
package | TEXT | Name of the package containing the policy function if the function belongs to a package. |
function | TEXT | Name of the policy function. |
sel | TEXT | Whether or not the policy applies to SELECT commands. Possible values are YES or NO. |
ins | TEXT | Whether or not the policy applies to INSERT commands. Possible values are YES or NO. |
upd | TEXT | Whether or not the policy applies to UPDATE commands. Possible values are YES or NO. |
del | TEXT | Whether or not the policy applies to DELETE commands. Possible values are YES or NO. |
idx | TEXT | Whether or not the policy applies to index maintenance. Possible values are YES or NO. |
chk_option | TEXT | Whether or not the check option is in force for INSERT and UPDATE commands. Possible values are YES or NO. |
enable | TEXT | Whether or not the policy is enabled on the object. Possible values are YES or NO. |
static_policy | TEXT | Whether or not the policy is static. Included only for compatibility. Always set to NO. |
policy_type | TEXT | Policy type. Included only for compatibility. Always set to UNKNOWN. |
long_predicate | TEXT | Included only for compatibility. Always set to YES. |