Re: Listing all tables with vpd policies

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_at_ngc.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Hallas
> Sent: Thursday, November 08, 2007 11:00 AM
> To: Schauss, Peter; oracle-l_at_freelists.org
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l