RE: dbms_pipe

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 15 Sep 2004 15:32:36 -0400
Message-ID: <BAY2-F10tL2xDNJScj00000487f@hotmail.com>

This is a bug while upgrading from 8i to 9i DBA role is missing this privilege.
Work around
grant select any dictionary to dba;

Regards
Rafiq

From: "David Boyd" <davidb1588_at_hotmail.com> Reply-To: davidb1588_at_hotmail.com
To: Bruce.Reardon_at_comalco.riotinto.com.au, oracle-l_at_freelists.org Subject: RE: dbms_pipe
Date: Wed, 15 Sep 2004 10:47:44 -0400

Hi Bruce,

Thanks for your response.

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

David

>From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon_at_comalco.riotinto.com.au>
>Reply-To: Bruce.Reardon_at_comalco.riotinto.com.au
>To: <davidb1588_at_hotmail.com>, <oracle-l_at_freelists.org>
>Subject: RE: dbms_pipe
>Date: Wed, 15 Sep 2004 08:40:25 +1000
>
>Hi David,
>How did you upgrade?
>Did you use an export by chance (which would exclude sys grants)?
>Privileges granted through a role (eg DBA execute any proc) don't work =
>in stored code but do from SQL / anonymous PL SQL
>so, that (I believe) is why you can execute from anonymous code but not =
>from a stored procedure.
>
>In your test system, try logging on as sysdba and granting execute on =
>sys.dbms_pipe to account_owner.
>
>IF that works, keep a separate script(s) of all the sys grants - these =
>would need to be rerun if rebuilding from an export
>
>Do you still have a version of your 8174 database available?
>You could see if this had been done by using
> select * from dba_tab_privs where grantee=3D'account_owner'
>OR
>select * from dba_tab_privs where grantor =3D 'SYS'
>and grantee IN ( select username from dba_users)
>
>HTH,
>Bruce Reardon
>

---

Express yourself instantly with MSN Messenger! Download today - it's FREE! hthttp://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
hthttp://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 16 2004 - 02:21:25 CDT