Home » RDBMS Server » Security » Auditing DML - Terminal
Auditing DML - Terminal [message #319588] Mon, 12 May 2008 05:38 Go to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Hi,

Is it possible to store client terminal name while connecting
to oracle database thru Dot Net server? and How?

Becoz, thru trigger if i store terminal/machine from v$session,
it will store value of Dot Net Server and not of client terminal.

Client -> dot net server -> Oracle DB server
I want to store client info and not dot net server info.

Thanks and regards,

MSMallya
Re: Auditing DML - Terminal [message #319593 is a reply to message #319588] Mon, 12 May 2008 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle can only know what you give it to it.
Your application server knows the client terminal, if you want to log it into Oracle server, the application server must give it to Oracle, for instance using dbms_application_info package or using "context".

Regards
Michel
Re: Auditing DML - Terminal [message #319600 is a reply to message #319593] Mon, 12 May 2008 06:24 Go to previous message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Thanks Michel.

Regards,

MSMallya
Previous Topic: How to provide the table space?
Next Topic: How to know the last access to a table?
Goto Forum:
  


Current Time: Fri Mar 29 07:17:55 CDT 2024