VIEW: SYS.KU$_FGA_POLICY_VIEW

Source

View Text - Preformatted

SELECT '1','2',
         f.obj#,
         f.pname,
         TO_CLOB(replace ((f.ptxt), '''', '''''')),
         f.pfschma, f.ppname, f.pfname,
         cast(multiset(select c.name from sys.col$ c, sys.fgacol$ fc where
                       fc.obj# = f.obj# and
                       fc.pname = f.pname and
                       fc.obj#  = c.obj# and fc.intcol# = c.intcol#
                       )
              as ku$_fga_rel_col_list_t),
         f.enable_flag,
         BITAND(NVL(f.stmt_type, 1),15),
         BITAND(NVL(f.stmt_type, 0),64),
         BITAND(NVL(f.stmt_type, 1),128),
         value(sov),
         u.name
  FROM   sys.ku$_schemaobj_view sov, sys.fga$ f, sys.user$ u
  WHERE  f.obj# = sov.obj_num  AND
         u.user# = f.powner# AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0 OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '2'
, F.OBJ#
, F.PNAME
, TO_CLOB(REPLACE ((F.PTXT)
, ''''
, ''''''))
, F.PFSCHMA
, F.PPNAME
, F.PFNAME
, CAST(MULTISET(SELECT C.NAME
FROM SYS.COL$ C
, SYS.FGACOL$ FC WHERE FC.OBJ# = F.OBJ# AND FC.PNAME = F.PNAME AND FC.OBJ# = C.OBJ#
AND FC.INTCOL# = C.INTCOL# ) AS KU$_FGA_REL_COL_LIST_T)
, F.ENABLE_FLAG
, BITAND(NVL(F.STMT_TYPE
, 1)
, 15)
, BITAND(NVL(F.STMT_TYPE
, 0)
, 64)
, BITAND(NVL(F.STMT_TYPE
, 1)
, 128)
, VALUE(SOV)
, U.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW SOV
, SYS.FGA$ F
, SYS.USER$ U
WHERE F.OBJ# = SOV.OBJ_NUM AND U.USER# = F.POWNER# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))