Sunday, August 16, 2015

Oracle : Script show which objects have auditing turned on

select
     substrb(owner,1,9) OWNER,
     substrb(object_name,1,14) OBJ_NAME,
     substrb(object_type,1,3) TYP,
     alt,aud,com,del,gra,ind,ins,loc,ren,sel,upd,ref,exe
     from dba_obj_audit_opts
     where
     greatest(alt,greatest(aud,greatest(com,greatest(del,greatest(gra,greatest(
     ind,greatest(ins,greatest(loc,greatest(ren,greatest(sel,greatest(
     upd,greatest(ref,exe)))))))))))) > '-/-'
     order by 1,3,2
     /

No comments:

Post a Comment