向Oracle中的另一个架构授予对队列的权限 [英] Grant permission to queues to another schema in oracle

问题描述

我在一个架构中有一个Oracle队列，即aqs

Hi I have a oracle queue in one schema namely aqs

样本队列

   BEGIN DBMS_AQADM.CREATE_QUEUE(
     Queue_name          => 'AQS.MOb_MSG',
     Queue_table         => 'AQS.MOb_QT',
     Queue_type          =>  0,
     Max_retries         =>  5,
     Retry_delay         =>  0,
     dependency_tracking =>  FALSE,
     comment             => 'SAMPLE');
  END;

我已经创建了相应的队列表.它工作正常.

I have the corresponding Queue table created.It works fine.

现在，我确实想使用另一个名为"mob"的模式为队列提供选择授予.如何为队列的另一个模式提供授予?我是否需要为队列或队列表提供选择访问权限.

Now i do want to provide the select grant for the queue using another schema named "mob".How do i provide grant to another schema for a queue?Do i need to provide the select access for the queue or queue table.

我尝试使用AQS.MOb_MSG上的Grant select来mob，它不起作用！说对象不存在.

I tried using grant select on AQS.MOb_MSG to mob , it is not working! saying object does not exists.

推荐答案

EXECUTE DBMS_AQADM.grant_queue_privilege ( 
   privilege     =>     'ALL', or (enqueue) or (dequeue)
   queue_name    =>     'AQS.MOb_MSG', 
   grantee       =>     'grantee_user', 
   grant_option  =>      FALSE/TRUE);

如果要授予直接访问队列表的权限.您必须执行此操作.grant select on MOb_QT to xxxx

If you want grant direct access to queue table. You have to do this.grant select on MOb_QT to xxxx

这篇关于向Oracle中的另一个架构授予对队列的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！