Distributed Databases   «Prev 

Preparing to use Advanced Queuing in Oracle


The first step in preparing to use advanced queueing is to adjust the parameter of the database

You must login as SYS or SYSTEM and grant a privilege to the user

After creating a queue, the owner of the queue can allow other users to submit messages to the queue. To do this, the owner of the queue must grant other users these two privileges: (1) The ENQUEUE ANY QUEUE system privilege ( or the ENQUEUE object privilege on a specific queue), and (2) the DEQUEUE ANY QUEUE system privilege (or the DEQUEUE object privilege on a specific queue.)