bugtraq - Auditing clients program in Oracle

lists.openwall.net		lists / announce owl-users owl-dev john-users john-dev passwdqc-users yescrypt popa3d-users / oss-security kernel-hardening musl sabotage tlsify passwords / crypt-dev xvendor / Bugtraq Full-Disclosure linux-kernel linux-netdev linux-ext4 linux-hardening linux-cve-announce PHC
Open Source and information security mailing list archives

Hash Suite for Android: free password hash cracker in your pocket

[<prev] [next>] [day] [month] [year] [list]

Date: Mon, 24 Sep 2007 14:58:46 -0700 (PDT)
From: fryxar fryxar <fryxar@...oo.com.ar>
To: bugtraq@...urityfocus.com
Subject: Auditing clients program in Oracle



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