VIEW: SYS.KU$_RLS_POLICY_OBJNUM_VIEW

Source

View Text - Preformatted

select
          r.obj#, r.pname, r.pfschma, r.ppname, r.pfname,
          value(sov)
  from    ku$_schemaobj_view sov, sys.rls$ r
  where   r.obj# = sov.obj_num and
          (SYS_CONTEXT('USERENV','CURRENT_USERID') in (sov.owner_num, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT R.OBJ#
, R.PNAME
, R.PFSCHMA
, R.PPNAME
, R.PFNAME
, VALUE(SOV)
FROM KU$_SCHEMAOBJ_VIEW SOV
, SYS.RLS$ R
WHERE R.OBJ# = SOV.OBJ_NUM AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (SOV.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))