VPD policy metadata
The Oracle Server maintains the association information between the security policies and schema objects in data dictionary views. The data dictionaries available for this information is USER_DEPENDENCIES
, ALL_DEPENDENCIES
, and DBA_DEPENDENCIES
. The structure of the dictionary view is as follows:
SQL> DESC USER_POLICIES Name Null? Type ------------------------------------------------- OBJECT_NAME NOT NULL VARCHAR2(30) POLICY_GROUP NOT NULL VARCHAR2(30) POLICY_NAME NOT NULL VARCHAR2(30) PF_OWNER NOT NULL VARCHAR2(30) PACKAGE VARCHAR2(30) FUNCTION NOT NULL VARCHAR2(30) SEL VARCHAR2(3) INS VARCHAR2(3) UPD VARCHAR2(3) DEL VARCHAR2(3) IDX VARCHAR2...