Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to group synonyms ?
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 Received on Thu Nov 27 2003 - 03:50:38 CST