Re: Avoid a synonym
- From: "Nuno Souto" <nsouto@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 2 Nov 2004 11:51:52 +1100 (EST)
On Tue, November 2, 2004 7:16 am, DENNIS WILLIAMS said:
> 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.
Sorry to ask the obvious question, but
*why* don't you just use private synonyms?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
