DBA Data[Home] [Help]

VIEW: SYS.KU$_AUDIT_DEFAULT_VIEW

Source

View Text - Preformatted

select '1','0',
         o.obj#,
         t.audit$,
         sys.dbms_metadata_util.get_audit_default(o.obj#)
  from   tab$ t, obj$ o
  where  o.name = '_default_auditing_options_'
    and  o.owner# = 0
    and  t.obj# = o.obj#
    and  trim('-' from replace(t.audit$,chr(0),'-')) IS NOT NULL
View Text - HTML Formatted

SELECT '1'
, '0'
, O.OBJ#
, T.AUDIT$
, SYS.DBMS_METADATA_UTIL.GET_AUDIT_DEFAULT(O.OBJ#)
FROM TAB$ T
, OBJ$ O
WHERE O.NAME = '_DEFAULT_AUDITING_OPTIONS_'
AND O.OWNER# = 0
AND T.OBJ# = O.OBJ#
AND TRIM('-'
FROM REPLACE(T.AUDIT$
, CHR(0)
, '-')) IS NOT NULL