Auditing clients program in Oracle

[fryxar fryxar <fryxar () yahoo com ar>]

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