RE: dbms_pipe
- From: "David Boyd" <davidb1588@xxxxxxxxxxx>
- To: Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- 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@xxxxxxxxxxxxxxxxxxxxxxx>
>Reply-To: Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx
>To: <davidb1588@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
>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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
