RE: dbms_pipe

I know I'm a couple of days late, but I'll add in my two cents anyway.

In Oracle 8.1, the parameter O7_DICTIONARY_ACCESSIBILITY was set to TRUE by default.
In Oracle 9.2, the parameter O7_DICTIONARY_ACCESSIBILITY is set to FALSE by default.

If the parameter is TRUE, then system privilege "execute any procedure", granted directly to the procedure owner, will allow you to execute sys.dbms_pipe from inside a stored procedure (which could have been your 8.1 situation).

If the parameter is FALSE, then system privilege "execute any procedure", granted directly to the procedure owner, is insufficient to allow you to execute sys.dbms_pipe from inside a stored procedure (which is probably your 9.2 situation). You will need to grant "execute on sys.dbms_pipe" as you found out.

In 9.2 there is a "select any dictionary" system privilege but there is no "execute any dictionary" system privilege.

-----Original Message-----

David Boyd

Thanks for your response.

The upgrade was not done by export. All of system privileges granted to the=20
account are preserved. Our prod is still in 8i. I compared the system=20 privileges granted the account in 8i and 9i. There is no difference except=20
the 'select any dictionary' in 9i. No row was returned when I did select *=20
from dba_tab_privs where grantee=3D'account_owner' in 8i.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 17 2004 - 19:47:53 CDT