Home » RDBMS Server » Security » Restrict Oracle access by User and IP Address
Restrict Oracle access by User and IP Address [message #119868] Mon, 16 May 2005 08:27 Go to next message
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?
Re: Restrict Oracle access by User and IP Address [message #119901 is a reply to message #119868] Mon, 16 May 2005 11:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the machine can be tracked through v$session.
use it with a logon trigger.
Re: Restrict Oracle access by User and IP Address [message #120068 is a reply to message #119901] Tue, 17 May 2005 10:48 Go to previous messageGo to next message
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
Re: Restrict Oracle access by User and IP Address [message #120194 is a reply to message #120068] Wed, 18 May 2005 06:43 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Thank you, Tom Kyte!

MHE
Re: Restrict Oracle access by User and IP Address [message #120446 is a reply to message #120068] Thu, 19 May 2005 16:28 Go to previous message
wejder
Messages: 7
Registered: May 2005
Location: Warsaw
Junior Member

see

SYS.V_$SESSION

and

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

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


Current Time: Fri Mar 29 08:15:39 CDT 2024