Bugtraq mailing list archives
Auditing clients program in Oracle
From: fryxar fryxar <fryxar () yahoo com ar>
Date: Mon, 24 Sep 2007 14:58:46 -0700 (PDT)
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
Current thread:
- Auditing clients program in Oracle fryxar fryxar (Sep 24)