RE: Listing all tables with vpd policies
- From: "Schauss, Peter" <peter.schauss@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Nov 2007 15:50:52 -0600
These seem to be the wrong policies. I am looking for virtual private
database policies, not audit policies.
Thanks,
Peter Schauss
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Hallas
Sent: Thursday, November 08, 2007 11:00 AM
To: Schauss, Peter; oracle-l@xxxxxxxxxxxxx
Subject: RE: Listing all tables with vpd policies
Describe DBA_AUDIT_POLICIES
SQL> desc DBA_AUDIT_POLICIES
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_SCHEMA NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
POLICY_NAME NOT NULL VARCHAR2(30)
POLICY_TEXT VARCHAR2(4000)
POLICY_COLUMN VARCHAR2(30)
PF_SCHEMA VARCHAR2(30)
PF_PACKAGE VARCHAR2(30)
PF_FUNCTION VARCHAR2(30)
ENABLED VARCHAR2(3)
SEL VARCHAR2(3)
INS VARCHAR2(3)
UPD VARCHAR2(3)
DEL VARCHAR2(3)
AUDIT_TRAIL VARCHAR2(12)
POLICY_COLUMN_OPTIONS VARCHAR2(11)
-----Original Message-----
Subject: Listing all tables with vpd policies
How can I list all tables in a schema which have vpd policies? The
V$VPD_POLICY view does not give me the information that I need since it
lists only those policies currently in the library cache. I note also
that this view includes multiple entries for each policy, apparently
based on the fact that different users get different predicates.
BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW.
Registered in England with company number 2777575.
http://www.bjss.co.uk
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
