Hei...
Inside trigger block, using userenv('terminal') you can identify the machine
name.
One oracle user can have multiple active sessions.
(Here in my team, 5 people working on the same oracle username with
different machines.
The privileges are set for them at application level.)
HTH.
Nirmal.,
-----Original Message-----
[mailto:PK_Deepa/VGIL@;vguard.satyam.net.in]
Sent: Tuesday, November 05, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
Hello
A user log is maintained for a table.I want to log all updations made to
this table.
I have written a database trigger (After Update) to log the changes to
another table.My requirement is to find the machine name from which the
updation has occurred and log the machine name also .
How to get the currently working session ID so that machine name can be
retrieved fromV$session view or any other method to retrive the machine
name uniquely.
Is it that one Oracle user can have multiple active sessions on different
machines? Eg.
User Name Status Module Session Machine
XX ACTIVE SQL*Plus 10 AA
XX ACTIVE SQL*Plus 19 BB
Regards,
Deepa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
