create_aq_frank.sql

create user frank identified by SuperSecretPassword1234;

grant connect to frank;
grant resource to frank;
grant execute on dbms_aq to frank;
grant execute on dbms_aqadm to frank;
grant execute on dbms_aqin to frank;
grant unlimited tablespace to frank;

BEGIN
   ORDS_ADMIN.ENABLE_SCHEMA(
     p_enabled => TRUE,
     p_schema => 'FRANK',
     p_url_mapping_type => 'BASE_PATH',
     p_url_mapping_pattern => 'frank',
     p_auto_rest_auth => TRUE
   );
   COMMIT;
END;
/