Re: Listing all tables with vpd policies
- From: "Rakesh Tikku" <rakesh.tikku@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Thu, 8 Nov 2007 14:41:43 -0800
Peter,
dba_policies should give you the information you are looking for.
desc dba_policies
Name Null? Type
----------------------------------------- --------
----------------------------
OBJECT_OWNER VARCHAR2(30)
OBJECT_NAME VARCHAR2(30)
POLICY_GROUP VARCHAR2(30)
POLICY_NAME VARCHAR2(30)
PF_OWNER VARCHAR2(30)
PACKAGE VARCHAR2(30)
FUNCTION VARCHAR2(30)
SEL VARCHAR2(3)
INS VARCHAR2(3)
UPD VARCHAR2(3)
DEL VARCHAR2(3)
CHK_OPTION VARCHAR2(3)
ENABLE VARCHAR2(3)
STATIC_POLICY VARCHAR2(3)
hth,
Rakesh Tikku
On 11/8/07, Schauss, Peter <peter.schauss@xxxxxxx> wrote:
>
> 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:
