Re: Avoid a synonym

alter session set current_user=<user you want to use)

if your tables are in several users, then this won't work.

• Original message --------------

> I have a group of users that should only see a subset of data in certain
> tables. They share a role. I will create a view that implements that, and
> add it to their role. Then, to allow them to use the same queries as other
> users, I will have them individually create private synonyms that point to
> their views. Does anyone know of a better way, where each user won't have to
> create several private synonyms? This is Oracle 9i.
>
>
> Dennis Williams
>
> DBA
>
> Lifetouch, Inc.
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l