quick pl/sql question 2004-04-22 - By David Sharples
OK,
Doesn 't quite work, the owner of the package is not the same person who
is executing the package.
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.
Should it work?
__ ____ ____ ____ ____ ____ ____
From: David Sharples
Sent: 21 April 2004 20:37
To: oracle-l@(protected)
Subject: RE: quick pl/sql question
Worked like a dream, thanks!
__ ____ ____ ____ ____ ____ ____
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
