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(3) CHK_OPTION VARCHAR2(3) ENABLE VARCHAR2(3) STATIC_POLICY VARCHAR2(3) POLICY_TYPE ...
Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
