RE: Avoid a synonym

Dennis
You could avoid synonyms by creating the views in the users' schemas :-)  

-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Tuesday, November 02, 2004 11:58 AM To: nsouto_at_bizmail.com.au; oracle-l_at_freelists.org Subject: RE: Avoid a synonym

Nuno - Good point (as always). My reasons are as follows:

1. The application group has their strategy built around public synonyms.
2. My boss likes public synonyms.
3. As I recall, it was Jonathan Lewis who mentioned that public synonyms could cause performance problems, and I have passed that along to my boss.. If anyone has a personal horror story to share, that might make an impact..

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nuno Souto
Sent: Monday, November 01, 2004 6:52 PM
To: oracle-l_at_freelists.org
Subject: Re: Avoid a synonym

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?

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