Re: how to group synonyms ?

francis.berges_at_laposte.net wrote:
> Hello,
>
> I run some oracle databases, each of them hosting several
> applications.
>
> Through i try to say devellopers to use full paths to tables ( ie
> shema_name.table_name ) i have some apps which still use public
> synonyms.
>
> As a user can use many of the apps of one database, i can have
> problems if the
> user want to create a local table with the same name than a public
> synonym.
>
> What i would like would be to gather "user synonyms" in a role
> definition, but i do not know how to do it ??
>
> Thank you
>
> Francis

Don't use synonyms, don't specify schema's.

After logon, set current_schema to the application you want to work with.

-- 

Gerard H. Pille

(plaats puntjes tussen mijn initialen om te antwoorden)