RE: Listing all tables with vpd policies

From: John Hallas <john.hallas_at_bjss.co.uk>
Date: Thu, 8 Nov 2007 15:59:46 -0000
Message-ID: <E02CB9B2777CF8459C86C49B48C48EC6029CFFDC@exchange.bjss.co.uk>

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 Received on Thu Nov 08 2007 - 09:59:46 CST