Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_pipe

dbms_pipe

From: David Boyd <davidb1588_at_hotmail.com>
Date: Tue, 14 Sep 2004 16:52:48 -0400
Message-ID: <BAY10-F56I9mK6PYzDa00018663@hotmail.com>


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
Received on Tue Sep 14 2004 - 16:10:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US