Oracle AQ高级队列

最新推荐文章于 2025-07-12 14:23:34 发布

原创最新推荐文章于 2025-07-12 14:23:34 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #user #interface #dictionary #sql

Oracle 专栏收录该内容

1 篇文章

订阅专栏

博客介绍了Oracle AQ相关内容。DBMS_AQ包提供消息任务接口，使用需有AQ_USER_ROLE角色；DBMS_AQADM包提供管理任务接口，使用需有AQ_ADMINISTRATOR_ROLE角色。还可通过查询数据字典视图验证结果，同时给出在SQL Plus设置用户权限的语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

The DBMS_AQ package provides an interface to the messaging tasks of Oracle AQ. To use these procedures, you must have been granted the new role, AQ_USER_ROLE

The DBMS_AQADM package provides an interface to the administrative tasks of Oracle AQ. To use these procedures, a DBMS_AQADM user must have been granted the new role, AQ_ADMINISTRATOR_ROLE. You can verify the results of executing the DBMS_ AQADM package by querying the new Oracle AQ data dictionary views, USER_QUEUE_ TABLES and USER_QUEUES (DBA levels of these views are also available).

除此之外，还要设置一下用户的权利，在SQL Plus里面执行如下：

GRANT EXECUTE ON DBMS_AQADM TO user;
GRANT EXECUTE ON DBMS_AQ TO user;