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
