Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.26 DBA_POLICIES

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.26 DBA_POLICIES

The DBA_POLICIES view provides information on all policies in the database. This view is accessible only to superusers.

Name

Type

Description

object_owner

NAME

Name of the schema in which the object belongs.

object_name

NAME

Name of the object on which the policy applies.

policy_group

TEXT

Name of the policy group. Included for compatibility only; always set to an empty string.

policy_name

NAME

Name of the policy.

pf_owner

NAME

Name of the schema containing the policy function, or the schema containing the package that contains the policy function.

package

NAME

Name of the package containing the policy function if the function belongs to a package.

function

NAME

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 for compatibility only; always set to NO.

policy_type

TEXT

Policy type. Included for compatibility only; always set to UNKNOWN.

long_predicate

TEXT

Whether or not predicates longer than 4000 bytes can be returned by the policy function. Included for compatibility only; always set to YES.

Previous PageTable Of ContentsNext Page