Setting Up

In order to administer AQ streams, you must be granted appropriate privileges to enqueue, dequeue, and manage queues.

The following Oracle user privileges are required to use this functionality:

• To Create, Drop or Monitor your own Queues

  You must be granted EXECUTE rights on DBMS_AQADM.

• To Create, Drop or Monitor any Queues

  You must be granted EXECUTE rights on DBMS_AQADM and be granted AQ_ADMINISTRATOR_ROLE by another user who has been granted this role (SYS and SYSTEM are the granters of AQ_ADMINISTRATOR_ROLE).

• To ENQUEUE or DEQUEUE your own queues

  You must be granted EXECUTE rights on DBMS_AQ.

You can use grant Grant/Revoke Privileges Dialog to achieve this.

See Also: Grant/Revoke Privileges Dialog | Chapter 9 in Oracle® Streams Concepts and Administration