VIEW: SYS.DBA_POLICIES

Source

View Text - Preformatted

select u.name, o.name, r.gname, r.pname, r.pfschma, r.ppname, r.pfname,
       decode(bitand(r.stmt_type,1), 0, 'NO', 'YES'),
       decode(bitand(r.stmt_type,2), 0, 'NO', 'YES'),
       decode(bitand(r.stmt_type,4), 0, 'NO', 'YES'),
       decode(bitand(r.stmt_type,8), 0, 'NO', 'YES'),
       decode(bitand(r.stmt_type,2048), 0, 'NO', 'YES'),
       decode(r.check_opt, 0, 'NO', 'YES'),
       decode(r.enable_flag, 0, 'NO', 'YES'),
       decode(bitand(r.stmt_type,16), 0, 'NO', 'YES'),
       case bitand(r.stmt_type,16)+
            bitand(r.stmt_type,64)+
            bitand(r.stmt_type,128)+
            bitand(r.stmt_type,256)+
            bitand(r.stmt_type,8192)+
            bitand(r.stmt_type,16384)+
            bitand(r.stmt_type,32768)+
            bitand(r.stmt_type,524288)
         when 16 then 'STATIC'
         when 64 then 'SHARED_STATIC'
         when 128 then 'CONTEXT_SENSITIVE'
         when 256 then 'SHARED_CONTEXT_SENSITIVE'
         when 8192 then 'XDS1'
         when 16384 then 'XDS2'
         when 32768 then 'XDS3'
         when 524288 then 'OLS'
         else 'DYNAMIC'
       end,
   decode(bitand(r.stmt_type,512), 0, 'YES', 'NO')
from user$ u, "_CURRENT_EDITION_OBJ" o, rls$ r
where u.user# = o.owner#
and r.obj# = o.obj#

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, R.GNAME
, R.PNAME
, R.PFSCHMA
, R.PPNAME
, R.PFNAME
, DECODE(BITAND(R.STMT_TYPE
, 1)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(R.STMT_TYPE
, 2)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(R.STMT_TYPE
, 4)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(R.STMT_TYPE
, 8)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(R.STMT_TYPE
, 2048)
, 0
, 'NO'
, 'YES')
, DECODE(R.CHECK_OPT
, 0
, 'NO'
, 'YES')
, DECODE(R.ENABLE_FLAG
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(R.STMT_TYPE
, 16)
, 0
, 'NO'
, 'YES')
, CASE BITAND(R.STMT_TYPE
, 16)+ BITAND(R.STMT_TYPE
, 64)+ BITAND(R.STMT_TYPE
, 128)+ BITAND(R.STMT_TYPE
, 256)+ BITAND(R.STMT_TYPE
, 8192)+ BITAND(R.STMT_TYPE
, 16384)+ BITAND(R.STMT_TYPE
, 32768)+ BITAND(R.STMT_TYPE
, 524288) WHEN 16 THEN 'STATIC' WHEN 64 THEN 'SHARED_STATIC' WHEN 128 THEN 'CONTEXT_SENSITIVE' WHEN 256 THEN 'SHARED_CONTEXT_SENSITIVE' WHEN 8192 THEN 'XDS1' WHEN 16384 THEN 'XDS2' WHEN 32768 THEN 'XDS3' WHEN 524288 THEN 'OLS' ELSE 'DYNAMIC' END
, DECODE(BITAND(R.STMT_TYPE
, 512)
, 0
, 'YES'
, 'NO') FROM USER$ U
, "_CURRENT_EDITION_OBJ" O
, RLS$ R WHERE U.USER# = O.OWNER# AND R.OBJ# = O.OBJ#