| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: quick pl/sql question
OK, so it's not you who is going to execute this. It works when you do = it but not when someone else does it?
CREATE OR REPLACE PROCEDURE dave_test (p_user_id IN VARCHAR2)=20
AUTHID CURRENT_USER
AS
BEGIN
=20
=
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;
/
 |
 |