The OpenNET Project
 
Search (keywords):  SOFT ARTICLES TIPS & TRICKS SECURITY
LINKS NEWS MAN DOCUMENTATION


h=X-YMail-OSG:Received:X-Mailer:Date:From:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;


<< Previous INDEX Search src / Print Next >>
Date: Mon, 24 Sep 2007 14:58:46 -0700 (PDT)
From: fryxar fryxar <fryxar@yahoo.com.ar.>
Subject: Auditing clients program in Oracle
To: bugtraq@securityfocus.com
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


<< Previous INDEX Search src / Print Next >>




  Закладки на сайте
  Проследить за страницей
Created 1996-2014 by Maxim Chirkov  
ДобавитьРекламаВебмастеруГИД  
RUNNet TopList