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@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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: