Re: DB Link Between Prod and Test?
On Tue, 15 May 2001,Rocky Welch scribbled on the wall in glitter crayon: -How about creating a user that only has read-only rights? But that still allows the query from hell syndrome that can bring a prod box to it's knees. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Identical parts aren't. --Beach's Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
William: Check my old post. 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 You can limit CPU, memory usage, etc... Hope it helps - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 10:10 AM On Tue, 15 May 2001,Rocky Welch scribbled on the wall in glitter crayon: -How about creating a user that only has read-only rights? But that still allows the query from hell syndrome that can bring a prod box to it's knees. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Identical parts aren't. --Beach's Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Diego Cutrone INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L 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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
Can he be trusted NOT to run some horrible query that would bring Prod to its knees? [EMAIL PROTECTED] 05/15/01 03:00PM If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L 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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Tim Sawmiller INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
Yes, we were doing the same thing. Until I found the links. I've been trying in vain to explain what an FTS of our 6 million row G/L does to a production database. Did I mention that there was an ORDER BY clause on that query? sigh Good luck! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 13:26 To: Multiple recipients of list ORACLE-L Subject: DB Link Between Prod and Test? 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 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: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Link Between Prod and Test?
On Tue, 15 May 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: -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 -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? Don't go there. Been there, done that, got bit bad. Yes you can mess with the production data. Might work if the user on the production side lived in it's own tablespace and only had select privs on the production data. But I don't like the precedent. YMMV, yadda, yadda, yadda. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Random access is the optimum of the mass storages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
Title: RE: DB Link Between Prod and Test? I created a 'READER' id on production for our datawarehouse guys. The dblink connects from dw to production as user READER, and READER has select authority on the specific prod tables that they are supposed to be looking at. DW has multiple ids. The single dblink solves the problem of an expotential number of dblinks. The reader id cannot break anything, nor can it look into unauthorized tables. -Original Message- From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 12:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: DB Link Between Prod and Test? If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L 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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
Title: 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 - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Subject: DB Link Between Prod and Test? 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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
Title: RE: DB Link Between Prod and Test? I agree with that Matthew. But if you still have touse the link make sure you give the user the appropiate provilegesand 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 - Original Message - From: Adams, Matthew (GEA, 088130) To: 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 - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Subject: DB Link Between Prod and Test?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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Link Between Prod and Test?
Bill, Thanks for the info. You just provided me some ammo to shoot this one down :) Dennis Meng Database Administrator Focal Communications 847-954-8328 Thater, William To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ThaterW@telecc: rgy.net Subject: Re: DB Link Between Prod and Test? Sent by: root@fatcity. com 05/15/01 02:46 PM Please respond to ORACLE-L On Tue, 15 May 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: -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 -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? Don't go there. Been there, done that, got bit bad. Yes you can mess with the production data. Might work if the user on the production side lived in it's own tablespace and only had select privs on the production data. But I don't like the precedent. YMMV, yadda, yadda, yadda. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Random access is the optimum of the mass storages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Link Between Prod and Test?
How about creating a user that only has read-only rights? --- [EMAIL PROTECTED] wrote: 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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Rocky Welch Senior Consultant - Internet Services Group Arthur Andersen __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
Well, you could create a user in the production database that only has select privileges and then create the database link to access that account. The big thing you'd have to be careful of here is that the person doesn't try to run some crazy query that bogs down the production system (but you could probably deter that potential hazard by setting up a nice little resource restrictive profile for that account)... Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Tuesday, May 15, 2001 1:26 PM To: Multiple recipients of list ORACLE-L 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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Jeffery Stevenson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DB Link Between Prod and Test?
Dennis, We use DB links to allow selects where data info is needed on two instances. One is a report type and the other is being updated by the users all day. They work great. To keep the table naming simple and allow the application to be written on one development instance, I use synonyms to identify the tables over the link. Create synonym table1 for table1@dblink. ROR mª¿ªm [EMAIL PROTECTED] 05/15/01 03:00PM If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L 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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DB Link Between Prod and Test?
My concern with that would be the performance aspect. Giving someone access to run un optimized queries in Production could affect the overall response time. I would not allow it personally, plus if you allow it for one ,you've set a precedent Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 11:00 PM If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L 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 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: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Sam Roberts INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).