Oracle9i Application Developer's Guide - Advanced Queuing
Release 1 (9.0.1)

Part Number A88890-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Administrative Interface: Views, 8 of 21


Selecting Queues for Which User Has Queue Privilege

Figure 10-7 Use Case Diagram: Selecting Queues for which User has Queue Privilege


Text description of adq10qvw10.gif follows
Text description of the illustration adq10qvw10.gif

Name of View

QUEUE_PRIVILEGES

Purpose

This view describes queues for which the user is the grantor, or grantee, or owner, or an enabled role or the queue is granted to PUBLIC.

Table 10-7 QUEUE_PRIVILEGES
Column Name & Description  Null?  Type  

GRANTEE--Name of the user to whom access was granted 

NOT NULL 

VARCHAR2(30) 

OWNER--Owner of the queue 

NOT NULL 

VARCHAR2(30) 

NAME--Name of the queue 

NOT NULL 

VARCHAR2(30) 

GRANTOR--Name of the user who performed the grant 

NOT NULL 

VARCHAR2(30) 

ENQUEUE_PRIVILEGE--Permission to enqueue to the queue  

 

NUMBER(1 if granted, 0 if not) 

DEQUEUE_PRIVILEGE--Permission to dequeue to the queue 

 

NUMBER(1 if granted, 0 if not) 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback