Oracle-L: Re: Security, private vs. public synonyms and contention data di

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Fri, 11 Jul 2003 13:19:35 -0800
Message-ID: <F001.005C465B.20030711131935@fatcity.com>

RE: Security, private vs. public synonyms and contention data dictionaryA lot of people have posted messages like: "I have several applications in my DB, but I can't create new public synonyms for my new app, because public synonym with that name already exists!". So, this should be one major reason why not to use public synonyms,

But yes, check ixora, there is a very good explanation about impact of synonyms. Generally, public synonums are worst performance wise, private synonyms aren't that good either, referencing to tables directly in your SQL would be the fastest way (talking about parsing speed). Since from developers point of view hardcoding the schema names would be quite bad, there's an alternate solution of not hardcoding schema names to SQL, but using alter session set currecnt_schema in your application to set which schema should be used (of course in multi-schema environments you won't get away with that easily).

Tanel.

Original Message ----- From: Stephane Paquette To: Multiple recipients of list ORACLE-L Sent: Friday, July 11, 2003 10:49 PM Subject: RE: Security, private vs. public synonyms and contention data di

I think I remember Steve Adams posting something about performance and public synonyms, you may want to check its web site www.ixora.com.au

Stephane Paquette
Administrateur de bases de donnees

Database Administrator

Standard Life

www.standardlife.ca

Tel. (514) 499-7999 7470 and (514) 925-7187

stephane.paquette_at_standardlife.ca

    -----Original Message-----
    From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of Paula_Stankus_at_doh.state.fl.us     Sent: Friday, July 11, 2003 3:35 PM
    To: Multiple recipients of list ORACLE-L     Subject: RE: Security, private vs. public synonyms and contention data di

Question:

Are private versus public synonyms preferred for security? Are private syn. worse administration? Do 1,000 users with private syn. cause data dictionary contention?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Tanel Poder
INET: tanel.poder.003_at_mail.ee

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 Fri Jul 11 2003 - 16:19:35 CDT