Grant permission to queues to another schema in oracle
<p>Hi I have a oracle queue in one schema namely aqs</p>

<p><strong>sample queue</strong></p>

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

<p>I have the corresponding Queue table created.It works fine.</p>

<p>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. </p>

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