Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Security, private vs. public synonyms and contention data di
And put it in a trigger in case the schema must be changed or duplicated.
Or just to work around duhvelopers.
Jared
On Friday 11 July 2003 14:19, Tanel Poder wrote:
> 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: Jared Still INET: jkstill_at_cybcon.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 Fri Jul 11 2003 - 20:29:30 CDT
![]() |
![]() |