Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Listing all tables with vpd policies

Listing all tables with vpd policies

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Thu, 8 Nov 2007 09:36:50 -0600
Message-ID: <CD9150D80CFCFB42BC73C40791C1E019CF0BB8@XMBIL112.northgrum.com>


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.

This is Oracle 10.2.0.

Thanks,
Peter Schauss

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 08 2007 - 09:36:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US