Oracle-L: RE: connections based on ip address

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 22 May 2003 09:37:21 -0800
Message-ID: <F001.005A028C.20030522093721@fatcity.com>

Yes, I think the main advantage of the method I described is that you can do it on a per-application basis. Oracle seemed rather proud of it, so I thought I should mention it. If you don't need the per-application feature, it sounds like the other method is a LOT simpler.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, May 22, 2003 10:18 AM
To: Multiple recipients of list ORACLE-L

There is a way to do this in 8i w/o fine-grained access control. You setup a configuration file that you reference in your listener.ora - I swear!

Oracle OCP DBA

-----Original Message-----
<mailto:DWILLIAMS_at_LIFETOUCH.COM> ]

Sent: Thursday, May 22, 2003 10:37 AM
To: Multiple recipients of list ORACLE-L

Pradeep

There is a new 9i feature that may be helpful. Use this link (you'll have

to patch it back together, and then search for "address" http://www.csis.gvsu.edu/GeneralInfo/Oracle/appdev.920/a96590/adgsec02.htm#1
<http://www.csis.gvsu.edu/GeneralInfo/Oracle/appdev.920/a96590/adgsec02.htm#
1>
006752
This describes a new Oracle9i feature called application context, part of fine-grained access control.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, May 22, 2003 8:12 AM
To: Multiple recipients of list ORACLE-L

Dear All,

Can somebody help me on this question ? I have a db server with ip address, say ip1 and an application server with ip address say, ip2 ?
Can I say in my Oracle db server that I will accept only the connections from ip2 ? ( some sort firewall rule)

Thanks and regards,
Pradeep

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net


<http://www.orafaq.net>  

-- 
Author: 
  INET: pradeep_at_ibsplc.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com


<http://www.fatcity.com>  

San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net


<http://www.orafaq.net>  

-- 
Author: DENNIS WILLIAMS 
  INET: DWILLIAMS_at_LIFETOUCH.COM 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com


<http://www.fatcity.com>  

San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu May 22 2003 - 12:37:21 CDT