Is that true even thought I granted myself access to those procs directly?
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected) on behalf of Freeman, Donald
Sent: Wed 21/04/2004 18:17
To: oracle-l@(protected)
Subject: RE: quick pl/sql question
It 's not the execute you are having problems with. The access you have to the underlying objects is granted to you through a role. I don 't know if I 'm describing this exactly right but roles aren 't referred within PL/SQL so you have to have direct privs on the objects.
Or,You can add "AUTHID CURRENT_USER " like so,
CREATE OR REPLACE PROCEDUREdave.test (whatever varchar2)
AUTHID CURRENT_USER
AS.....
That should do the trick...
> -- --Original Message-- --
> From: oracle-l-bounce@(protected)
> [mailto:oracle-l-bounce@(protected)]On Behalf Of David Sharples
> Sent: Wednesday, April 21, 2004 12:17 PM
> To: oracle-l@(protected)
> Subject: RE: quick pl/sql question
>
>
> Thanks but.
>
> SQL > connect / as sysdba
> Connected.
> SQL > grant execute on dbms_resource_manager to cerebrus;
>
> Grant succeeded.
>
> SQL > grant execute on dbms_resource_manager_privs to cerebrus;
>
> Grant succeeded
>
> SQL > connect cerebrus/cerebrus
> Connected.
>
> SQL > exec dave_test( 'ds ');
> BEGIN dave_test( 'ds '); END;
>
> *
> ERROR at line 1:
> ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist
> ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_RMIN ", line 56
> ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_RESOURCE_MANAGER_PRIVS ", line 99
> ORA-06512 (See ORA-06512.ora-code.com): at "CEREBRUS.DAVE_TEST ", line 3
> ORA-06512 (See ORA-06512.ora-code.com): at line 1
>
>
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
