auditting problem ...(urgent)
hi
I enabled auditting alter any procedure in db
audit alter any procedure by monitoruser;
then i altered procedure by monitoruser
ALTER PROCEDURE monitoruser.TRYME COMPILE REUSE SETTINGS;
but i see no result regarding this alter procedure ,does anyone know why ?
this is the query i use:
select username,os_username,userhost host,owner,obj_name,action_name action,timestamp time from dba_audit_trail where timestamp>sysdate-2 and obj_name like 'TRYME%';
audit alter any procedure by monitoruser;
then i altered procedure by monitoruser
ALTER PROCEDURE monitoruser.TRYME COMPILE REUSE SETTINGS;
but i see no result regarding this alter procedure ,does anyone know why ?
this is the query i use:
select username,os_username,userhost host,owner,obj_name,action_name action,timestamp time from dba_audit_trail where timestamp>sysdate-2 and obj_name like 'TRYME%';
0