VIEW: SYS.DBA_SEC_RELEVANT_COLS

Source

View Text - Preformatted

select u.name, o.name, r.gname, r.pname, c.name,
       decode(bitand(r.stmt_type, 4096), 0, 'NONE', 'ALL_ROWS')
from sys.rls$ r, sys.rls_sc$ sc, sys.user$ u, sys.obj$ o, sys.col$ c
where u.user# = o.owner#
  and r.obj# = o.obj#
  and r.obj# = sc.obj#
  and r.gname=sc.gname and r.pname=sc.pname
  and r.obj# = c.obj# and sc.intcol# = c.intcol#
  and bitand(c.property, 32) = 0

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, R.GNAME
, R.PNAME
, C.NAME
, DECODE(BITAND(R.STMT_TYPE
, 4096)
, 0
, 'NONE'
, 'ALL_ROWS') FROM SYS.RLS$ R
, SYS.RLS_SC$ SC
, SYS.USER$ U
, SYS.OBJ$ O
, SYS.COL$ C WHERE U.USER# = O.OWNER#
AND R.OBJ# = O.OBJ#
AND R.OBJ# = SC.OBJ#
AND R.GNAME=SC.GNAME
AND R.PNAME=SC.PNAME
AND R.OBJ# = C.OBJ#
AND SC.INTCOL# = C.INTCOL#
AND BITAND(C.PROPERTY
, 32) = 0