AOH :: Oracle :: TB12693.HTM

Auditing clients program in Oracle

Auditing clients program in Oracle
Auditing clients program in Oracle



=0A=0AHi! Since I=0Aneed to audit the clients program used to access to my Oracle Database=0A(feature not supported by Oracle audit), I created the following trigger to do=0Ait. I Hope it will be helpful for=0Asomebody else=85=0A=0A=0A =0A=0A=0Acreate or replace trigger=0Alogon_program c=0A=0A=0Adeclare r_session=0Av$session%rowtype;=0A=0A=0Abegin=0A=0A=0A select *=0Ainto r_session=0A=0A=0A from=0Av$session=0A=0A=0A where=0Aaudsid=userenv('SESSIONID');=0A=0A=0A =0A=0A=0A update sys.aud$=0Aset sqltext=r_session.program where sessionid=userenv('SESSIONID') and=0Aaction#=100;=0A=0A=0Aend;=0A=0A=0A =0A=0A=0ARegards=0A=0A=0AFryxar=0A=0A=0A=0A=0A=0A Segu=ED de cerca a la Selecci=F3n Argentina de Rugby en el Mundial de Francia 2007.=0Ahttp://ar.sports.yahoo.com/mundialderugby 

The entire AOH site is optimized to look best in Firefox® 3 on a widescreen monitor (1440x900 or better).
Site design & layout copyright © 1986-2009 AOH
We do not send spam. If you have received spam bearing an artofhacking.com email address, please forward it with full headers to abuse@artofhacking.com.