how to group synonyms ?

From: <francis.berges_at_laposte.net>
Date: 26 Nov 2003 10:45:09 -0800
Message-ID: <dd8b8d3f.0311261045.bc87633@posting.google.com>

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 Received on Wed Nov 26 2003 - 12:45:09 CST