title: Oracle Advanced QUEUE does not exist is other schema
body: <p>I have the same problem that is described in this issue: <a href="https://stackoverflow.com/questions/40657781/grant-permission-to-queues-to-another-schema-in-oracle">Grant permission to queues to another schema in oracle</a>.</p>
  
  <p>But given permissions to the other user doesn't work at all.</p>
  
  <p>My queue:</p>
  
  <pre><code>   DBMS_AQADM.create_queue_table (
        queue_table          =&gt; 'event_queue_tab',
        queue_payload_type   =&gt; 't_event_queue_payload',
        multiple_consumers   =&gt; TRUE,
        comment              =&gt; 'Queue Table For Event Messages',
        secure =&gt; false);
  
     -- Create the event queue.
     DBMS_AQADM.create_queue (queue_name    =&gt; 'event_queue',
                              queue_table   =&gt; 'event_queue_tab');
  
     -- Start the event queue.
     DBMS_AQADM.start_queue (queue_name =&gt; 'event_queue');
  </code></pre>
  
  <p>This queue as created using schema <code>USER1</code>. In this schema, I have a package <code>pkg1</code> with a procedure when I call it, its enqueue:</p>
  
  <pre><code>PROCEDURE proc1
     IS
        PRAGMA AUTONOMOUS_TRANSACTION;
        l_enqueue_options      DBMS_AQ.ENQUEUE_OPTIONS_T;
        l_message_properties   DBMS_AQ.MESSAGE_PROPERTIES_T;
        l_message_handle       RAW (16);
        l_queue_msg            t_event_queue_payload;
     BEGIN
        l_queue_msg := t_event_queue_payload ('give_me_a_prod');
  
        DBMS_AQ.enqueue (queue_name           =&gt; 'event_queue',
                         enqueue_options      =&gt; l_enqueue_options,
                         message_properties   =&gt; l_message_properties,
                         payload              =&gt; l_queue_msg,
                         msgid                =&gt; l_message_handle);
        COMMIT;
     EXCEPTION
        WHEN OTHERS
        THEN
           DBMS_OUTPUT.put_line (
              SQLERRM || ' - ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
     END proc1;
  </code></pre>
  
  <p>I have a second schema USER2 who have privileges to execute <code>pkg1</code> by a specific ROLE (ROLE1). But when he calls proc1, receive the next error:</p>
  
  <pre><code>ORA-24010: QUEUE USER2.EVENT_QUEUE does not exist - ORA-06512: at "SYS.DBMS_AQ", line 180
  ORA-06512: at "USER1.PKG1", line 1808
  </code></pre>
  
  <p>I've executed this privilege command in USER1 but without success:</p>
  
  <pre><code>BEGIN
     DBMS_AQADM.grant_queue_privilege (privilege      =&gt; 'ALL',
                                       queue_name     =&gt; 'USER1.event_queue',
                                       grantee        =&gt; 'USER2',
                                       grant_option   =&gt; TRUE);
  END;
  </code></pre>
  
  <p>I'm really starting to understand how Ad.Queues works. Am I missing something here? Thanks.</p>
  
  <p><strong>EDIT1:</strong>
  After the grant given the privileges for this queue:</p>
  
  <pre><code>SELECT grantee,
         owner,
         name,
         grantor,
         enqueue_privilege,
         dequeue_privilege
    FROM queue_privileges
   WHERE name = upper('event_queue');
  
  ROLE1   USER1   EVENT_QUEUE USER1   1   1
  USER2   USER1   EVENT_QUEUE USER1   1   1
  </code></pre>