Re: how to group synonyms ?

francis.berges_at_laposte.net wrote:

> Hello,
>
> The information about my question was not complete. The apps on
> database use one or more shemas and user of the app has the roles of
> the apps but not by default.
>
> When he connects to the application, the application has admin option
> on the differents roles she needs and grant the user the role(s) he
> needs ( reading the dba_roles_privs ).
>
> Some of the applications are old, i am not allowed to modify source
> and i don't want to user hundreds of public synonyms per instance.
> Furthermore, i would like to move shemas between databases painless (
> by export/import ).
>
> thank you for your precedent answers !
>
> Hope the information is complete now
>
> thanks again
>
> Francis

Synonyms yes. Public synonyms ... quite another thing entirely.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)