[Home] [Help] [Dependency Information]
Object Name: | DBA_POLICIES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All row level security policies in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_OWNER | VARCHAR2 | (128) | Yes | Owner of the synonym, table, or view |
OBJECT_NAME | VARCHAR2 | (128) | Yes | Name of the synonym, table, or view |
POLICY_GROUP | VARCHAR2 | (128) | Yes | Name of the policy group |
POLICY_NAME | VARCHAR2 | (128) | Yes | Name of the policy |
PF_OWNER | VARCHAR2 | (128) | Yes | Owner of the policy function |
PACKAGE | VARCHAR2 | (128) | Name of the package containing the policy function | |
FUNCTION | VARCHAR2 | (128) | Yes | Name of the policy function |
SEL | VARCHAR2 | (3) | If YES, policy is applied to query on the object | |
INS | VARCHAR2 | (3) | If YES, policy is applied to insert on the object | |
UPD | VARCHAR2 | (3) | If YES, policy is applied to update on the object | |
DEL | VARCHAR2 | (3) | If YES, policy is applied to delete on the object | |
IDX | VARCHAR2 | (3) | If YES, policy is applied to IDX on the object | |
CHK_OPTION | VARCHAR2 | (3) | Is check option enforced for this policy? | |
ENABLE | VARCHAR2 | (3) | Is this policy is enabled? | |
STATIC_POLICY | VARCHAR2 | (3) | Is this policy is static? | |
POLICY_TYPE | VARCHAR2 | (24) | policy types | |
LONG_PREDICATE | VARCHAR2 | (3) | If YES, maximum predicate size can be 32K |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_OWNER
, OBJECT_NAME
, POLICY_GROUP
, POLICY_NAME
, PF_OWNER
, PACKAGE
, FUNCTION
, SEL
, INS
, UPD
, DEL
, IDX
, CHK_OPTION
, ENABLE
, STATIC_POLICY
, POLICY_TYPE
, LONG_PREDICATE
FROM SYS.DBA_POLICIES;
|
|
|