From oracle-l-bounce@freelists.org Tue Sep 14 16:10:51 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8ELApN22059 for ; Tue, 14 Sep 2004 16:10:51 -0500 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 i8ELApI22054 for ; Tue, 14 Sep 2004 16:10:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0AF2372CEE4; Tue, 14 Sep 2004 16:16:26 -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 32186-45; Tue, 14 Sep 2004 16:16:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F195372CF08; Tue, 14 Sep 2004 16:16:24 -0500 (EST) X-Originating-IP: [128.205.133.126] X-Originating-Email: [davidb1588@hotmail.com] X-Sender: davidb1588@hotmail.com From: "David Boyd" To: oracle-l@freelists.org Subject: dbms_pipe Date: Tue, 14 Sep 2004 16:52:48 -0400 Mime-Version: 1.0 Content-type: text/plain Message-ID: X-OriginalArrivalTime: 14 Sep 2004 20:52:48.0977 (UTC) FILETIME=[CB4F6410:01C49A9C] Content-Transfer-Encoding: 8bit X-archive-position: 9487 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: davidb1588@hotmail.com Precedence: normal Reply-To: davidb1588@hotmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org We upgraded a database from 8.1.7.4 to 9.2.0.5 recently. The database is for one application only. So the account for the application was granted all the system privileges directly in 8i. A procedure in a package owned by the account calls DBMS_PIPE. In 8i the account was not granted 'execution on dbms_pipe' explicitly. After the upgrade, the package body became invalid. I got "PLS-00201: identifier 'DBMS_PIPE' must be declared" when I compiled the package. Then I tried to grant the DBA role to the account. An anonymous block that calls dbms_pipe ran successfully. But I still could not compile the package until I granted the 'execution on dbms_pipe' to the account explicitly. Does any one know if the privilege has been changed in 9i? I cannot find any thing in the document. Our DBA role is a default role from Oracle + 'select any dictionary'. _________________________________________________________________ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- http://www.freelists.org/webpage/oracle-l