Hi, Yes it does work if run as the owner of the package, doesn't work when someone with execute on that package tries it -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Igor Neyman Sent: 22 April 2004 13:54 To: oracle-l@xxxxxxxxxxxxx Subject: RE: quick pl/sql question Does it work if executed by the owner of the package? Igor Neyman, OCP DBA ineyman@xxxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Sharples Sent: Thursday, April 22, 2004 4:49 AM To: oracle-l@xxxxxxxxxxxxx Subject: FW: quick pl/sql question OK, =20 Doesn't quite work, the owner of the package is not the same person who is executing the package. =20 Anyone know how to get it so any user can run it. Again it was failing on the dbms_resource_manager part - That user does have execute permission on those procedures. =20 Should it work? =20 ________________________________ From: David Sharples=20 Sent: 21 April 2004 20:37 To: oracle-l@xxxxxxxxxxxxx Subject: RE: quick pl/sql question =20 Worked like a dream, thanks! =20 ________________________________ 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 = =3D to the underlying objects is granted to you through a role. I don't know =3D if I'm describing this exactly right but roles aren't referred within = =3D PL/SQL so you have to have direct privs on the objects. =3D20 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 >=3D20 >=3D20 > Thanks but. >=3D20 > SQL> connect / as sysdba > Connected. > SQL> grant execute on dbms_resource_manager to cerebrus; >=3D20 > Grant succeeded. >=3D20 > SQL> grant execute on dbms_resource_manager_privs to cerebrus; >=3D20 > Grant succeeded >=3D20 > SQL> connect cerebrus/cerebrus > Connected. >=3D20 > SQL> exec dave_test('ds'); > BEGIN dave_test('ds'); END; >=3D20 > * > 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 >=3D20 > >=3D20 ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------