Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I get a client's IP Address?

Re: How do I get a client's IP Address?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Tue, 8 Sep 1998 19:59:08 +0200
Message-ID: <6t3r73$aa6$1@newton.a2000.nl>


>I need to
>uniquely identify a client machine's connection from within Oracle.

You might also use sessionid:

    select userenv( 'sessionid' )
    from dual;

To get the IP address, you need to setup auditing. I will take a look in my docs and post more details tomorrow, if still needed...

Arjan. Received on Tue Sep 08 1998 - 12:59:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US