Home » RDBMS Server » Security » How to log program and module used by any session (Oracle 9.2.0.1.0, Windows 2000)
How to log program and module used by any session [message #360162] Wed, 19 November 2008 22:51 Go to next message
SilverChi
Messages: 17
Registered: September 2006
Junior Member
I've set the audit_trail option to true.
In Aud$ table i found the audit log data, but there's no information about what program or module that used by every logged sessionID.
What should i do to get those information and how to save those to a permanent table.?


Regards..

Report message to a moderator

Re: How to log program and module used by any session [message #360167 is a reply to message #360162] Wed, 19 November 2008 23:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to create a logon trigger to record this information in your own audit table.

Regards
Michel

Report message to a moderator

icon14.gif  Re: How to log program and module used by any session [message #360231 is a reply to message #360167] Thu, 20 November 2008 02:20 Go to previous message
SilverChi
Messages: 17
Registered: September 2006
Junior Member
great advice !!
its work smoothly

Fully regards..

Report message to a moderator

Previous Topic: Getting metadatas with a remote user
Next Topic: OID issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 25 03:50:41 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.