| 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: Using fully qualified table_name.database_object in
Our application vendor code doesn't pre-qualify table references and to
isolate batch processes from running under the object owner. I use synonyms
(public) so the code doesn't have to change but I get the security isolation
that I want. <Wouldn't want a developer sliding a drop table into his code
or perhaps a delete/update to the vendor's audit trail.>
I have 5800 synonyms in our OLTP environment and about 1300 in our reporting environment. I have not found it difficult to manage (well not very - the wrapped database links are a little more work) and our application is always changing (or so it seems).
What's the big deal with herding cats. The sleep for like 23 1/2 hrs a day.
David Davis
Manulife Financial
>From: "Nelson, Allan" <anelson_at_midf.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Using fully qualified table_name.database_object in
>Date: Mon, 24 Feb 2003 10:18:53 -0800
>
>Most application developers in my experience are in love with synonyms
>exactly so they won't have to fully qualify the table name. Oracle uses
>them fairly extensively in APPs. They do require some overhead for
>looking up the synonym and they can be a mess if nested deeply enough.
>Controlling use of synonyms on the other hand is a lot like herding
>cats.
>
>Allan
>
>-----Original Message-----
>From: laura pena [mailto:lizzpenaorclgrp_at_yahoo.com]
>Sent: Monday, February 24, 2003 10:29 AM
>To: Multiple recipients of list ORACLE-L
>code?
>
>
>
>I would like to know if it is advocated to use fully qualified
>table_name.database objects in application code.
>
>Example would be schema.table_name in a PL/SQL code.
>
>I would like to know the Pros/Cons if there are any?
>
>Thanks in advance.
>
>
>
>
> _____
>
>Do you Yahoo!?
>Yahoo!
><http://rd.yahoo.com/finance/mailtagline/*http://taxes.yahoo.com/> Tax
>Center - forms, calculators, tips, and more
>
>
>______________________________________________________________________________
>This email is intended solely for the person or entity to which it is
>addressed and may contain confidential and/or privileged information.
>Copying, forwarding or distributing this message by persons or entities
>other than the addressee is prohibited. If you have received this email in
>error, please contact the sender immediately and delete the material from
>any computer. This email may have been monitored for policy compliance.
>[021216]
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: ddoralist_at_hotmail.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).Received on Mon Feb 24 2003 - 15:52:40 CST
 |
 |