RE: Avoid a synonym

Thanks very much, Bruce, and thanks for all that provided ideas. Since Tim Gorman was just at our local Oracle user's group (TCOUG), this is very timely.

Dennis Williams
DBA
Lifetouch, Inc.

-----Original Message-----

From: McCartney, Bruce [mailto:BMcCartney_at_talisman-energy.com] Sent: Monday, November 01, 2004 2:52 PM
To: DENNIS WILLIAMS; oracle-l_at_freelists.org Subject: RE: Avoid a synonym

Dennis,
Look into "virtual private database" . Tim Gorman has a presentation and sample on his web site evdbt.com. you need "enterprise edition"

Bruce

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS Sent: Monday, November 01, 2004 1:16 PM
To: oracle-l_at_freelists.org
Subject: Avoid a synonym

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 Received on Mon Nov 01 2004 - 15:49:02 CST