Re: get remote ip and port for logged user

From: Joe Kazimierczyk <joseph.kazimierczyk_at_bms.com>
Date: Mon, 02 Apr 2001 08:13:40 -0400
Message-ID: <3AC86CF4.353AB97@bms.com>

This only answers part of your question, but with session auditing enabled, dba_audit_trail.comment_text can show the remote ip and port # where the connection originated from:

Authenticated by: DATABASE; Cl
ient address: (ADDRESS=(PROTOC
OL=tcp)(HOST=999.999.99.99)(PO
RT=9999))

Shahar Shocron wrote:
>
> Hi
>
> I'm trying to create a security package that authenticate
> a user externaly trough external procedures
> I can get the variable for remote ip address
> sys_context('env',ip_address')
>
> but that's not enough in order for my external procedure to work
> I need to pass it
> local ip, local port, remote ip, remote port
>
> how can I do that. where can I get these on the server
> and if they don't exist on the server how can I get them dinamicaly
> after logon without requesting user input or execution of a stored
> procedure.
>
> thanx
>
> Shahar
Received on Mon Apr 02 2001 - 07:13:40 CDT