From oracle-l-bounce@freelists.org Mon Nov 1 14:12:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iA1KCu606225 for ; Mon, 1 Nov 2004 14:12:56 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iA1KCuI06220 for ; Mon, 1 Nov 2004 14:12:56 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0C17F72D642; Mon, 1 Nov 2004 15:18:59 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18301-57; Mon, 1 Nov 2004 15:18:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 193E472D662; Mon, 1 Nov 2004 15:18:57 -0500 (EST) Message-ID: <6BA0194B4809D9118361000F1F6C95100197EA32@exchmn4.lifetouch.com> From: DENNIS WILLIAMS To: oracle-l@freelists.org Subject: Avoid a synonym Date: Mon, 1 Nov 2004 14:16:23 -0600 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 11732 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: DWILLIAMS@LIFETOUCH.COM X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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