Re: table synonyms

Am Dienstag, den 24.05.2005, 10:37 -0500 schrieb Mike Nolan:
> > > I hope anybody can help me on this subject. The problem is not to find
> > > a substitute for the Oracle synonyms, but a way to write queries
> > > which, reliably, can be used no matter the schema which owns the
> > > tables.
> >
> > Maybe you use views?
>
> Unless it changed in 8, you can't insert into or update a view.
>
> I don't know if rules will do the trick or not, to be honest I haven't
> figured out what they can and cannot do.

Yes, since views are basically constructed via rules, you can extend
them with rules for update, insert etc. as well.

> As someone who used to use synonyms at the user/schema level in Oracle
> as a way to restrict access to a subset tables based on user-specific
> criteria (eg, restricting salesman 'X' to only his accounts in the customer
> master table), yes, synonyms would be nice.

Views I'd say. Or you do it via SRF (set returning functions)
to isolate access.