OraFAQ Forum: Security » Auditing DML

Home » RDBMS Server » Security » Auditing DML - Terminal

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Auditing DML - Terminal [message #319588]

Mon, 12 May 2008 05:38

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

Report message to a moderator

Re: Auditing DML - Terminal [message #319593 is a reply to message #319588]

Mon, 12 May 2008 05:56

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Auditing DML - Terminal [message #319600 is a reply to message #319593]

Mon, 12 May 2008 06:24

msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT

Member

Thanks Michel.

Regards,

MSMallya

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 08:02:53 CST 2025