Re: WorkstationID from Oracle trigger
From: DanHW <danhw_at_aol.com>
Date: 17 Dec 1999 02:19:48 GMT
Message-ID: <19991216211948.10800.00001407_at_ng-cr1.aol.com>
Date: 17 Dec 1999 02:19:48 GMT
Message-ID: <19991216211948.10800.00001407_at_ng-cr1.aol.com>
>Do you know how to get the workstation id or LAN ID from within an Oracle
>trigger for the user that executed the sql ?
Query the v$session and/or v$process table. One of them has it. You will also need to query the environ function to get the users SID.
Dan Hekimian-Williams Received on Fri Dec 17 1999 - 03:19:48 CET