TUCoPS :: 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 

TUCoPS is optimized to look best in Firefox® on a widescreen monitor (1440x900 or better).
Site design & layout copyright © 1986-2024 AOH