OraFAQ Forum: Security » Restrict Oracle access by User and IP Address

Home » RDBMS Server » Security » Restrict Oracle access by User and IP Address

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

Restrict Oracle access by User and IP Address [message #119868]

Mon, 16 May 2005 08:27

mad2005
Messages: 2
Registered: May 2005

Junior Member

Hi

I would like to know if it is possible to restrict the access to my oracle DB (8i version) to a given user when it try to login thru a given IP Address?

Report message to a moderator

Re: Restrict Oracle access by User and IP Address [message #119901 is a reply to message #119868]

Mon, 16 May 2005 11:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

the machine can be tracked through v$session.
use it with a logon trigger.

Report message to a moderator

Re: Restrict Oracle access by User and IP Address [message #120068 is a reply to message #119901]

Tue, 17 May 2005 10:48

mad2005
Messages: 2
Registered: May 2005

Junior Member

Hi

Where can I find the IP Address of the machine's user? Is there any field in an Oracle table?

Thanks

Report message to a moderator

Re: Restrict Oracle access by User and IP Address [message #120194 is a reply to message #120068]

Wed, 18 May 2005 06:43

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Thank you, Tom Kyte!

MHE

Report message to a moderator

Re: Restrict Oracle access by User and IP Address [message #120446 is a reply to message #120068]

Thu, 19 May 2005 16:28

wejder
Messages: 7
Registered: May 2005
Location: Warsaw

Junior Member

see

SYS.V_$SESSION

and

select SYS_CONTEXT('USERENV','IP_ADDRESS') from dual;

Report message to a moderator

Previous Topic:	Connect with special application to DB.
Next Topic:	Security

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 16 22:52:20 CDT 2026