Date: Mon, 24 Sep 2007 14:58:46 -0700 (PDT)
From: fryxar fryxar <fryxar@yahoo.com.ar.>
Subject: Auditing clients program in Oracle
To: [email protected]
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Message-ID: <693654.57053.qm@web38306.mail.mud.yahoo.com.>
X-Virus-Scanned: antivirus-gw at tyumen.ru
=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 fo=
llowing 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=0Ad=
eclare r_session=0Av$session%rowtype;=0A=0A=0Abegin=0A=0A=0A select *=0A=
into r_session=0A=0A=0A from=0Av$session=0A=0A=0A where=0Aaudsid=3Dus=
erenv('SESSIONID');=0A=0A=0A =0A=0A=0A update sys.aud$=0Aset sqltext=
=3Dr_session.program where sessionid=3Duserenv('SESSIONID') and=0Aaction#=
=3D100;=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 Mund=
ial de Francia 2007.=0Ahttp://ar.sports.yahoo.com/mundialderugby
