RE: Avoid a synonym
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "McCartney, Bruce" <BMcCartney@xxxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 1 Nov 2004 15:52:21 -0600
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@xxxxxxxxxxxxxxxxxxx]
Sent: Monday, November 01, 2004 2:52 PM
To: DENNIS WILLIAMS; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS
Sent: Monday, November 01, 2004 1:16 PM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
