db queue grant and revoke

来源：互联网发布：c语言算法描述举例编辑：程序博客网时间：2024/06/05 16:57

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');

0 0