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
/
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