Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: connections based on ip address

RE: connections based on ip address

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Thu, 22 May 2003 07:17:41 -0800
Message-ID: <F001.0059FED2.20030522071741@fatcity.com>


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-----
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 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
--

Author:
  INET: pradeep_at_ibsplc.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).
--

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).

--

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

Author:
  INET: Paula_Stankus_at_doh.state.fl.us

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 - 10:17:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US