sys.all_synonyms should tell you. But also consider that they don't have to
have their own synonymns, only an object with the same name (see
all_objects).
<francis.berges_at_laposte.net> wrote in message
news:dd8b8d3f.0311261045.bc87633_at_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 - 14:02:43 CST
