DBMS_AQADM: GRANT_SYSTEM_PRIVILEGE

create user aq_priv_tst_usr identified by pw;

begin
--                                    privilege      grantee           admin option
--                                    ----------- ,  --------------- , ------------
   dbms_aqadm.grant_system_privilege('ENQUEUE_ANY', 'AQ_PRIV_TST_USR', FALSE       );
   dbms_aqadm.grant_system_privilege('DEQUEUE_ANY', 'AQ_PRIV_TST_USR', FALSE       );
   dbms_aqadm.grant_system_privilege('MANAGE_ANY' , 'AQ_PRIV_TST_USR', TRUE        );
end;
/

select privilege, admin_option from dba_sys_privs  where grantee = 'AQ_PRIV_TST_USR';
--
-- PRIVILEGE                                ADM
-- ---------------------------------------- ---
-- DEQUEUE ANY QUEUE                        NO 
-- ENQUEUE ANY QUEUE                        NO 
-- MANAGE ANY QUEUE                         YES

begin
--                                    privilege      grantee           admin option
--                                    ----------- ,  --------------- , ------------
   dbms_aqadm.grant_system_privilege('XYZ'        , 'AQ_PRIV_TST_USR', FALSE       );
end;
/