Oracle8i Application Developer's Guide - Advanced Queuing
Release 2 (8.1.6)

Part Number A76938-01

Library

Product

Contents

Index

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

Administrative Interface: Views, 8 of 16


Select Queues for Which User Has Queue Privilege

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



To refer to the table of all basic operations having to do with the Operational Interface see:

 

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-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index