Distributed Databases   «Prev 

Preparing to use Advanced Queuing in Oracle


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

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

3) 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.)