Re: Corporate Wide Public Synonyms ++ multiple schemas

Mark C. Stock apparently said,on my timestamp of 12/02/2005 2:45 AM:
>
> actually my point is that a single application uses multiple schemas --
> which in my experience is typically the case. there are always at lease a
> few common tables, and there are often cross-schema references. in other
> words, not every table that the application accesses is always going to be
> in the target schema

Sure. That is my experience as well. Various schemas, one or more applications, mix and match. Which means absence of synonyms is not at all practical.

However if you pour through the available data on bad synonyms, you'll find that it's the PUBLIC synonyms that are real killers. PRIVATE synonyms are nowhere near as bad. So once again, mix and match: use the logon trigger to set the schema with the majority of tables and either use owner.table syntax or PRIVATE synonyms from the majority schema to the others. Works for me.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam