From oracle-l-bounce@freelists.org Mon Apr 25 15:24:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3PKOKxW011235 for ; Mon, 25 Apr 2005 15:24:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3PKOF4Z011229 for ; Mon, 25 Apr 2005 15:24:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1816E1864EE; Mon, 25 Apr 2005 13:32:17 -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 01143-10; Mon, 25 Apr 2005 13:32:17 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 920651864CA; Mon, 25 Apr 2005 13:32:16 -0500 (EST) Date: Mon, 25 Apr 2005 14:30:19 -0400 From: Ray Stell To: oracle-l Subject: view privilege Message-ID: <20050425183019.GA11810@locust.cns.vt.edu> Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i Content-Transfer-Encoding: 8bit X-archive-position: 18965 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: stellr@cns.vt.edu Precedence: normal Reply-To: stellr@cns.vt.edu X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.63 >From the 9.2 docs: The owner of the view (whether it is you or another user) must have been explicitly granted privileges to access all objects referenced in the view definition. The owner cannot have obtained these privileges through roles. What is the logic behind the role restriction? Why is a role less secure in the ora architecture? Thanks. ============================================================ Ray Stell stellr@vt.edu (540) 231-4109 Tempus fugit 28^D -- http://www.freelists.org/webpage/oracle-l