Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: connections based on ip address
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).
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