Re: find out who is connected to server, How ?

Vivekanandhan Raja (vraja_at_us.oracle.com) wrote:
: HI Janos,
 

: This solution of placing USERNAME in the CONFIG.ORA / ORACLE.INI will
: not work against all servers. This is highly dependent on the Listener.
: e.g. none of this works against Windows NT SQL*Net Listeners!!!! SQL*Net
: V2 relies on the presence of AUTHENTICATION adapters to obtain the OS
: UserName. Setting plaintext parameters like USERNAME in files leaves the
: door open for security breaches (I guess u are already aware of this).

Is there a good reason why SQL*Net cannot place the network address of the connecting terminal (IP address, OSI address... whatever) into the appropriate field of whatever base table so that it appears in the terminal field of v$session?

You frustratedly

--
Chris Selwyn
Senior Consultant
Perihelion Software
email: chris_at_perihelion.co.uk tel: +44 1749 344203