I agree with that Matthew.
But if you still have to use the link make
sure you give the user the appropiate provileges and
assign him a "profile" to limit the ammount of
resources he can consume with his queries.
This way he can't slow down the prod instance
significantly.
greetings
DC
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Adams,
Matthew (GEA, 088130)
To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L
Sent: Tuesday, May 15, 2001 4:56 PM
Subject: RE: DB Link Between Prod and
Test?
Is he an idiot? (I couldn't resist)
We go to extreme lengths to ensure
that nobody can link our devlopement and production
databases together in any shape or form. It's
just a bad idea.
- R. Matt Adams - GE
Appliances - <A
href="mailto:matt.adams_at_appl.ge.com">matt.adams_at_appl.ge.com
Meddle not in the affairs of troff, <FONT
size=2> for it is subtle and quick to anger.
> -----Original Message----- >
From: dmeng_at_focal.com [<A
href="mailto:dmeng_at_focal.com">mailto:dmeng_at_focal.com] <FONT
size=2>> Sent: Tuesday, May 15, 2001 2:26 PM >
To: Multiple recipients of list ORACLE-L > Subject:
DB Link Between Prod and Test? > <FONT
size=2>> > One of our development DBAs suggested
today to build a > private database
> link between production and test database so that he can
run some > queries against both at the same time. I
am a little > concerned because he <FONT
size=2>> might make a mistake and accidentally corrupt the prod
> database. Anybody >
out there who is doing the same thing? Are there any other potential
> ramifications? > TIA
> Dennis Meng > Database
Administrator > Focal Communications
> 847-954-8328 >
> -- > Please see the
official ORACLE-L FAQ: <A href="http://www.orafaq.com"
target=_blank>http://www.orafaq.com > --
> Author: >
INET: dmeng_at_focal.com > <FONT
size=2>> 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). >
Received on Tue May 15 2001 - 15:32:38 CDT
