Re: how to populate v$session.machine for SQL*Net connections

From: Jeremy Barnsley <jeremy.barnsley_at_syntegra.bt.co.uk>
Date: 1997/05/01
Message-ID: <3368EBBC.7CF5@syntegra.bt.co.uk>#1/1

You can only do it (via Oracle) using 7.3 (not 7.2).

In 7.3

---

The IP address get recorded in comment$text in the AUD$ table if you audit logons/logoffs (i.e. 'audit session'). The port number is also recorded.

In 7.2

---

Very messy and has to be done at Unix level. Not easy.

Jez. Received on Thu May 01 1997 - 00:00:00 CDT