DBA_POLICIES v17

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

NameTypeDescription
object_ownerTEXTName of the owner of the object.
schema_nameTEXTName of the schema in which the object resides.
object_nameTEXTName of the object to which the policy applies.
policy_groupTEXTName of the policy group. Included only for compatibility. Always set to an empty string.
policy_nameTEXTName of the policy.
pf_ownerTEXTName of the schema containing the policy function or the schema containing the package that contains the policy function.
packageTEXTName of the package containing the policy function if the function belongs to a package.
functionTEXTName of the policy function.
selTEXTWhether or not the policy applies to SELECT commands. Possible values are YES or NO.
insTEXTWhether or not the policy applies to INSERT commands. Possible values are YES or NO.
updTEXTWhether or not the policy applies to UPDATE commands. Possible values are YES or NO.
delTEXTWhether or not the policy applies to DELETE commands. Possible values are YES or NO.
idxTEXTWhether or not the policy applies to index maintenance. Possible values are YES or NO.
chk_optionTEXTWhether or not the check option is in force for INSERT and UPDATE commands. Possible values are YES or NO.
enableTEXTWhether or not the policy is enabled on the object. Possible values are YES or NO.
static_policyTEXTIncluded only for compatibility. Always set to NO.
policy_typeTEXTIncluded only for compatibility. Always set to UNKNOWN.
long_predicateTEXTIncluded only for compatibility. Always set to YES.