Worked like a dream, thanks! ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Freeman, Donald Sent: Wed 21/04/2004 18:17 To: oracle-l@xxxxxxxxxxxxx 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. =20 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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David Sharples > Sent: Wednesday, April 21, 2004 12:17 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: quick pl/sql question >=20 >=20 > Thanks but. >=20 > SQL> connect / as sysdba > Connected. > SQL> grant execute on dbms_resource_manager to cerebrus; >=20 > Grant succeeded. >=20 > SQL> grant execute on dbms_resource_manager_privs to cerebrus; >=20 > Grant succeeded >=20 > SQL> connect cerebrus/cerebrus > Connected. >=20 > SQL> exec dave_test('ds'); > BEGIN dave_test('ds'); END; >=20 > * > ERROR at line 1: > ORA-00942: table or view does not exist > ORA-06512: at "SYS.DBMS_RMIN", line 56 > ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER_PRIVS", line 99 > ORA-06512: at "CEREBRUS.DAVE_TEST", line 3 > ORA-06512: at line 1 >=20 > >=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: application/ms-tnef -- File: winmail.dat ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------