pl/sql question

[davey23uk]

got this procedure on 9iR2

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,'users1',TRUE);
dbms_resource_manager.set_initial_consumer_group(p_user_id,'users1');
end;

I have execute on the dbms_resource* packages and it works.

now when I do this, i get erros

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 on cerebrus.dave_test to hangdam;

Grant succeeded.

SQL> conn hangdam/cerebrus
Connected.

SQL> exec cerebrus.dave_test('ds');
BEGIN cerebrus.dave_test('ds'); END;

*
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 4
ORA-06512: at line 1

Anyone know how I can it to work when running it not as the procedure owner?

Cheers

[davey23uk]

tried it with AUTHID DEFINER as well, doesnt worj then either.

Any ideas?

[dharma]

From the docs@tahiti.oracle.com

Requirements
The invoker must have the ADMINISTER_RESOURCE_MANAGER system privilege to execute these procedures. The procedures to grant and revoke this privilege are in the package DBMS_RESOURCE_MANAGER_PRIVS.

HTH
-dharma

[davey23uk]

yeah cheers, found that after much searching about - it got hidden for some sers having the dba privelege.

Thanks