IP address [message #299939] |
Wed, 13 February 2008 15:46 |
uicmxz
Messages: 48 Registered: July 2006
|
Member |
|
|
Is it possible to get the IP address for the user login in Oracle?
|
|
|
|
Re: IP address [message #300078 is a reply to message #300028] |
Thu, 14 February 2008 03:23 |
Rafeek
Messages: 159 Registered: April 2007 Location: egypt
|
Senior Member |
|
|
Quote: |
SELECT SYS_CONTEXT ('USERENV', 'CURRENT_USER'),
SYS_CONTEXT ('USERENV', 'OS_USER'),
SYS_CONTEXT ('USERENV', 'HOST'),
SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA'),
SYS_CONTEXT ('USERENV', 'IP_ADDRESS')
FROM DUAL;
|
|
|
|
|
|
|
|
|
Re: IP address [message #300492 is a reply to message #300490] |
Fri, 15 February 2008 11:56 |
|
Michel Cadot
Messages: 68686 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You need select privilege on v$session and execute privilege on utl_inaddr.
You NEVER use SYSDBA to query.
Give appropriate privileges to users.
Regards
Michel
|
|
|