create_privilege.sql

来自「Oracle Advance Queue(AQ)的使用例子」· SQL 代码 · 共 18 行

--
-- AQ administrator
DROP ROLE my_aq_adm_role;
CREATE ROLE my_aq_adm_role;
--
GRANT CONNECT, RESOURCE, aq_administrator_role TO my_aq_adm_role;
--
-- AQ users
DROP ROLE my_aq_user_role;
CREATE ROLE my_aq_user_role;
--
GRANT CREATE SESSION, aq_user_role TO my_aq_user_role;
--
EXEC DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE(PRIVILEGE=>'ENQUEUE_ANY',GRANTEE=>'my_aq_user_role', ADMIN_OPTION=>FALSE); 
EXEC DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE(PRIVILEGE=>'DEQUEUE_ANY',GRANTEE=>'my_aq_user_role', ADMIN_OPTION=>FALSE); 
--
EXIT;