| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: connections based on ip address
Dear All,
Thanks for all who have replied to my doubt. Now I have to try it out.
Regards,
Pradeep
DENNIS WILLIAMS
<DWILLIAMS_at_LIFE To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
TOUCH.COM> cc:
Sent by: Subject: RE: connections based on ip address
root_at_fatcity.co
m
05/22/03 11:07
PM
Please respond
to ORACLE-L
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.netReceived on Fri May 23 2003 - 06:51:39 CDT
<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). -- 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).
 |
 |