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).
