CONNECT sys/change_on_install as sysdba /* ** +----------------------------+ ** | AQ_ADMIN_PLSQL | ** +----------------------------+ */ DROP USER aq_admin_plsql CASCADE; CREATE USER aq_admin_plsql IDENTIFIED BY aq_admin_plsql DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; ALTER USER aq_admin_plsql QUOTA UNLIMITED ON users; GRANT aq_administrator_role TO aq_admin_plsql; GRANT connect TO aq_admin_plsql; GRANT create type TO aq_admin_plsql; EXECUTE dbms_aqadm.grant_type_access('aq_admin_plsql'); /* ** +----------------------------+ ** | AQ_USER_PLSQL | ** +----------------------------+ */ DROP USER aq_user_plsql CASCADE; CREATE USER aq_user_plsql IDENTIFIED BY aq_user_plsql DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT aq_user_role TO aq_user_plsql; GRANT connect TO aq_user_plsql;