Oracle Database Advanced Queue (AQ)

Grants:

For a oracle db user, to create queues, queue tables, listen onto the AQ's and consume messages and to send messages to AQ, the below grants need to be assigned.

GRANT AQ_ADMINISTRATOR_ROLE, AQ_USER_ROLE TO srini;
GRANT EXECUTE ON DBMS_AQADM TO srini;
GRANT EXECUTE ON DBMS_AQ TO srini;
GRANT EXECUTE ON DBMS_LOB TO srini;
GRANT EXECUTE ON DBMS_AQIN TO srini;
GRANT EXECUTE ON DBMS_AQJMS TO srini;
GRANT EXECUTE ON DBMS_JMS_PLSQL TO srini;


More to follow on this topic...