| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: User Log-Machine Name
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_at_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: PK_Deepa/VGIL_at_vguard.satyam.net.in
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Tue Nov 05 2002 - 03:28:41 CST
 |
 |