VIEW: SYS.USER_LOG_GROUPS

Source

View Text - Preformatted

select ou.name, oc.name, o.name,
       case c.type# when 14 then 'PRIMARY KEY LOGGING'
                    when 15 then 'UNIQUE KEY LOGGING'
                    when 16 then 'FOREIGN KEY LOGGING'
                    when 17 then 'ALL COLUMN LOGGING'
                    else 'USER LOG GROUP'
       end,
       case bitand(c.defer,64) when 64 then 'ALWAYS'
                               else  'CONDITIONAL'
       end,
       case bitand(c.defer,8) when 8 then 'GENERATED NAME'
                              else  'USER NAME'
       end
from sys.con$ oc,  sys.user$ ou,
     sys.obj$ o, sys.cdef$ c
where oc.owner# = ou.user#
  and oc.con# = c.con#
  and c.obj# = o.obj#
  and o.owner# = userenv('SCHEMAID')
  and
  (c.type# = 12 or c.type# = 14 or
   c.type# = 15 or c.type# = 16 or
   c.type# = 17)

View Text - HTML Formatted

SELECT OU.NAME
, OC.NAME
, O.NAME
, CASE C.TYPE# WHEN 14 THEN 'PRIMARY KEY LOGGING' WHEN 15 THEN 'UNIQUE KEY LOGGING' WHEN 16 THEN 'FOREIGN KEY LOGGING' WHEN 17 THEN 'ALL COLUMN LOGGING' ELSE 'USER LOG GROUP' END
, CASE BITAND(C.DEFER
, 64) WHEN 64 THEN 'ALWAYS' ELSE 'CONDITIONAL' END
, CASE BITAND(C.DEFER
, 8) WHEN 8 THEN 'GENERATED NAME' ELSE 'USER NAME' END FROM SYS.CON$ OC
, SYS.USER$ OU
, SYS.OBJ$ O
, SYS.CDEF$ C WHERE OC.OWNER# = OU.USER#
AND OC.CON# = C.CON#
AND C.OBJ# = O.OBJ#
AND O.OWNER# = USERENV('SCHEMAID') AND (C.TYPE# = 12 OR C.TYPE# = 14 OR C.TYPE# = 15 OR C.TYPE# = 16 OR C.TYPE# = 17)