V$VPD_POLICY definition in Oracle Database 11.2
V$VPD_POLICY

select
  ADDRESS,                                 -- ADDRESS RAW(8)
  PARADDR,                                 -- PARADDR RAW(8)
  SQL_HASH,                                -- SQL_HASH NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  CHILD_NUMBER,                            -- CHILD_NUMBER NUMBER
  OBJECT_OWNER,                            -- OBJECT_OWNER VARCHAR2(30)
  OBJECT_NAME,                             -- OBJECT_NAME VARCHAR2(30)
  POLICY_GROUP,                            -- POLICY_GROUP VARCHAR2(30)
  POLICY,                                  -- POLICY VARCHAR2(30)
  POLICY_FUNCTION_OWNER,                   -- POLICY_FUNCTION_OWNER VARCHAR2(30)
  PREDICATE                                -- PREDICATE VARCHAR2(4000)
from
  GV$VPD_POLICY
where
  inst_id = USERENV('Instance')

home |  up