db queue grant and revoke

最新推荐文章于 2021-04-12 12:29:03 发布

yaluo009

最新推荐文章于 2021-04-12 12:29:03 发布

阅读量448

点赞数

分类专栏： database

本文链接：https://blog.csdn.net/yaluo009/article/details/52880467

版权

database 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

1>grant

dbms_aqadm.grant_queue_privilege ('<privilege>','SYS.SYS$SERVICE_METRICS', '<user>');

for example:

exec dbms_aqadm.grant_queue_privilege ('DEQUEUE','SYS.SYS$SERVICE_METRICS', 'SCOTT');

SQL> select * from QUEUE_PRIVILEGES where grantee='SCOTT';

GRANTEE OWNER NAME GRANTOR ENQUEUE_PRIVILEGE DEQUEUE_PRIVILEGE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ----------------- -----------------
SCOTT SYS SYS$SERVICE_METRICS SYS 0 1

2>revoke

SQL> select * from dba_tab_privs where table_name like '%WF_JMS_OUT%';

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
APPS APPLSYS WF_JMS_OUT APPLSYS ENQUEUE YES NO
APPS APPLSYS WF_JMS_OUT APPLSYS DEQUEUE YES NO

SQL> EXECUTE DBMS_AQADM.REVOKE_QUEUE_PRIVILEGE( privilege => 'ENQUEUE', queue_name => 'APPLSYS.WF_JMS_OUT', grantee => 'APPS');

SQL> EXECUTE DBMS_AQADM.REVOKE_QUEUE_PRIVILEGE( privilege => 'DEQUEUE', queue_name => 'APPLSYS.WF_JMS_OUT', grantee => 'APPS');