Re: how to group synonyms ?

synonyms are either public (owned by PUBLIC and accessible to all users) or private (owned by, and accessible to, a single user) -- roles only group privileges

i highly recommend public synonyms for applications -- coding the schema name with the object creates maintenance and portability problems

however, if you are concerned about name-space collisions (i.e., if a user may be allowed to create a table with the same name as an application table referenced via the public synonym) establish a convention that all applications have a standard prefix which is used for all application tables and/or public synonyms to those tables, i. HR_ for human resources, SO_ for sales orders, etc.

just to clarify: the user (with appropriate privs) can always create an object with the same name as a public synonym, but the problems occur when Oracle give preference to the user's object instead of the object referenced by the public synonym. -- is this the problem you're trying to address

• mark stock

| <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:24:09 CST