Re: Public Synonyms

"Martin Doering" <doeringm_at_gmx.de> wrote in message news:ivh3dvcv9shbvcdvaf5de64l54dui5flfn_at_4ax.com...

> We have several bigger schemas in our database and the public synonyms
> of them tend to get in conflict with each others.

Ah yes. That's a problem.

>
> Is there a possiblity to make synonyms not public, but make some kind
> of synonym-groups or such in the same way, as I can grant table-access
> to roles? Some kind of profiles or such?

Create an "access user" for each schema/application. This is just a normal Oracle User but with just connect and create any synonym rights.

Grant access to tables on the original schema owners to these "access users" as needed. Then create the range of synonyms you need for each application within each of these users, as private synonyms.

Depending on which "acess user" your application code logs into, you get a different synonym "profile". BTW, these private synonyms won't suffer as much from the performance degradation that public synonyms cause.

HTH

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam