Oracle9i Application Developer's Guide - Advanced Queuing Release 1 (9.0.1) Part Number A88890-02 |
|
Managing AQ, 2 of 10
Configuration information can be managed through procedures in the DBMS_AQADM
package. Initially, only SYS
and SYSTEM
have execution privilege for the procedures in DBMS_AQADM
and DBMS_AQ
. Users who have been granted execute rights to these two packages will be able to create, manage, and use queues in their own schemas. Users also need the MANAGE
ANY
QUEUE
privilege to create and manage queues in other schemas.
The AQ_ADMINISTRATOR_ROLE
has all the required privileges to administer queues. The privileges granted to the role let the grantee:
DBMS_TRANSFORM
DBMS_AQELM
Y
ou should avoid granting AQ_USER_ROLE
in Oracle9i and 8.1 since this role will not provide sufficient privileges for enqueuing or dequeuing on Oracle9i or 8.1-compatible queues.
Your database administrator has the option of granting the system privileges ENQUEUE
ANY
QUEUE
and DEQUEUE
ANY
QUEUE
, exercising DBMS_AQADM
.GRANT_SYSTEM_PRIVILEGE
and DBMS_AQADM
.REVOKE_SYSTEM_PRIVILEGE
directly to a database user, provided that you wish the user to have this level of control. You as the application developer give rights to a queue by granting and revoking privileges at the object level by exercising DBMS_AQADM
.GRANT_QUEUE_PRIVILEGE
and DBMS_AQADM
.REVOKE_QUEUE_PRIVILEGE
.
As a database user, you do not need any explicit object-level or system-level privileges to enqueue or dequeue to queues in your own schema other than the execute right on DBMS_AQ
.
All internal AQ objects are now accessible to PUBLIC.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|