Re: Avoid a synonym

Perhaps a reference to USER_ROLE_PRIVS in the view ?

SF

DENNIS WILLIAMS wrote:

>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
>
>
>

-- 
Regards,

Stephane Faroult

RoughSea Ltd
http://www.roughsea.com

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