| 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:Fwd: Database access by extranet
Stephane,
I am running the same configurations as Dick. The only difference is that we are also running Oracle Applications and we had to open port 9000. Personally I don't think having a cloned database is a good idea. I'm concerned about which database is up to date, is it internal or external database (if both are being updated)?? .. I think having two databases doing the same job will cause more problems. If your more concerned about security than consistency of the database, then you could create a web based application that queries the database and returns the data through a web browser. That way users can only retrieve data you want them to view.
Cell: 603 315-9380
Work: 603 890-1703 x 4716
800 426-7767
dgoulet_at_vicr.com on 10/12/2000 09:30:36 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Glen Bernas/Whittman-Hart LP) Subject: Re:Fwd: Database access by extranet
Stephane,
Well, I'm not sure about those out there who are cloning their DB's for outside the firewall, but we've configured out Extranet to access the db inside the firewall. We're using a Raptor firewall which has a special configuration for SQL*Net connections and we've got it setup in a very strange way so that it would be impossible for someone outside to get in, at least before the alarms go off. I'm looking into separating the data needed by the extranet from the internal systems & placing that db between two firewalls in what's called the DMZ. But otherwise it has not been a problem. The DMZ idea is to allow for maintenance on the source system while allowing the external site to keep functioning.
Dick Goulet
____________________Reply Separator____________________ Author: =?iso-8859-1?q?paquette=20stephane?= <stephane_paquette_at_yahoo.com> Date: 10/12/00 12:50 AM
I've asked this question yesterday and got no answers. This is the second run. I'm sure sombody has a dss application accessed by extranet.
> Hi all,
>
> By the end of the year we'll have a small
> datawarehouse in production. It will be accessible
> internally but also by our extranet. The extranet
> team
> wants a second copy of the datawarehouse only for
> the
> extranet, so intruders have no physical access to
> the
> datawarehouse number 1.
>
> We may get the budget to clone all databases being
> accessed by the extranet.
> Anydody doing that ?
>
> TIA
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from
> anywhere!
> http://mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: stephane_paquette_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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-LReceived on Thu Oct 12 2000 - 09:59:31 CDT
 |
 |