Selecting Queues for Which User Has Any Privilege

Figure 10-6 Use Case Diagram: Selecting Queues for which User has Any Privilege

Text description of the illustration adq10qvw9.gif

Name of View

ALL_QUEUES

Purpose

This view describes all queues accessible to the user.

Table 10-6 ALL_QUEUES

Column Name & Description	Null?	Type
OWNER--Owner of the queue	NOT NULL	VARCHAR2(30)
NAME--Name of the queue	NOT NULL	VARCHAR2(30)
QUEUE_TABLE--Name of the table the queue data resides in	NOT NULL	VARCHAR2(30)
QID--Object number of the queue	NOT NULL	NUMBER
QUEUE_TYPE--Type of the queue		VARCHAR2(15)
MAX_RETRIES--Maximum number of retries allowed when dequeuing from the queue		NUMBER
RETRY_DELAY--Time interval between retries		NUMBER
ENQUEUE_ENABLED--Queue is enabled for enqueue		VARCHAR2(7)
DEQUEUE_ENABLED--Queue is enabled for dequeue		VARCHAR2(7)
RETENTION--Time interval processed messages retained in the queue		VARCHAR2(40)
USER_COMMENT--User specified comment		VARCHAR2(50)