quick pl/sql question 2004-04-22 - By David Sharples
Thanks again, still not working though
create or replace procedure dave_test (p_user_id IN varchar2)
AUTHID CURRENT_USER AS
begin
dbms_resource_manager_privs.grant_switch_consumer_group(p_user_id, 'users
1 ',TRUE);
dbms_resource_manager.set_initial_consumer_group(p_user_id, 'users1 ');
end;
/
Procedure created.
SQL >
SQL > connect / as sysdba
Connected.
SQL > grant execute on dbms_resource_manager_privs to hangdam;
Grant succeeded.
SQL > grant execute on dbms_resource_manager to hangdam;
Grant succeeded.
SQL > grant execute_catalog_role to hangdam;
Grant succeeded.
SQL > grant select_catalog_role to hangdam;
Grant succeeded.
SQL > connect hangdam/cerebrus;
Connected.
SQL > exec cerebrus.dave_test( 'ds ');
BEGIN cerebrus.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
If I run as the user who owns it...
SQL >
SQL > connect cerebrus/cerebrus
Connected.
SQL > exec cerebrus.dave_test( 'ds ');
PL/SQL procedure successfully completed.
Thanks
Dave
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Freeman, Donald
Sent: 22 April 2004 14:42
To: oracle-l@(protected)
Subject: RE: quick pl/sql question
You may have to issue one or both of the following grants to whoever you
=
want to run your procedure.
|
|
