RE: Avoid a synonym

From: James Thomson <jrthomso_at_uvic.ca>
Date: Mon, 1 Nov 2004 12:55:13 -0800
Message-ID: <GCELLMPCNKJGKKHHEJIDOELDCNAA.jrthomso@uvic.ca>

Have you looked into Virtual Private Database?

http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96582/toc.htm

-----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 12: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 - 14:49:02 CST