quick pl/sql question 2004-04-22 - By Freeman, Donald
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)
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;
/
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
