Auditing clients program in Oracle
Hi! Since I
need to audit the clients program used to access to my Oracle Database
(feature not supported by Oracle audit), I created the following trigger to do
it. I Hope it will be helpful for
somebody else?
create or replace trigger
logon_program c
declare r_session
v$session%rowtype;
begin
select *
into r_session
from
v$session
where
audsid=userenv('SESSIONID');
update sys.aud$
set sqltext=r_session.program where sessionid=userenv('SESSIONID') and
action#=100;
end;
Regards
Fryxar
Seguí de cerca a la Selección Argentina de Rugby en el Mundial de Francia
2007.
http://ar.sports.yahoo.com/mundialderugby