OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » IP address

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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?

Report message to a moderator

Re: IP address [message #300028 is a reply to message #299939]

Thu, 14 February 2008 01:02

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, use SYS_CONTEXT for current session.

Regards
Michel

Report message to a moderator

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;

Report message to a moderator

Re: IP address [message #300080 is a reply to message #300078]

Thu, 14 February 2008 03:27

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And what does this add to my previous post?

Regards
Michel

Report message to a moderator

Re: IP address [message #300086 is a reply to message #300080]

Thu, 14 February 2008 03:34

Rafeek
Messages: 159
Registered: April 2007
Location: egypt

Senior Member

sorry i donet read your post
rafeek

Report message to a moderator

Re: IP address [message #300468 is a reply to message #300078]

Fri, 15 February 2008 09:15

uicmxz
Messages: 48
Registered: July 2006

Member

How can I get IP addresses for all active sessions (all users connected to database)?

Report message to a moderator

Re: IP address [message #300470 is a reply to message #300468]

Fri, 15 February 2008 09:25

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select sid, machine, utl_inaddr.get_host_address(machine) ip 
from v$session 
where type='USER' and username is not null 
/

Regards
Michel

Report message to a moderator

Re: IP address [message #300490 is a reply to message #300470]

Fri, 15 February 2008 11:54

uicmxz
Messages: 48
Registered: July 2006

Member

Do I need to be connected as sysdba user to be able to run this query?

Report message to a moderator

Re: IP address [message #300492 is a reply to message #300490]

Fri, 15 February 2008 11:56

Michel Cadot
Messages: 68683
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

Report message to a moderator

Previous Topic:	Udump Error Defination
Next Topic:	Installing oracle automatic

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:48:05 CDT 2024