title: Is it possible to see a sequence in all_sequences without having the SELECT right on the sequence?
body: <p>I need to retrieve the list of available sequences of a certain database schema in an Oracle 10g database (10.2.0.3).</p>
  
  <p>With the schema owner, I can simply do something like the following to achieve this:</p>
  
  <pre><code>SELECT sequence_name FROM all_sequences WHERE sequence_owner = 'ABCDEF';
  </code></pre>
  
  <p>However, If I use a user which has a custom "read-only" role assigned, that user does not get any rows when executing that query.
  I've played around a bit and found out that granting the <code>SELECT</code> option on the sequences to the read-only role makes those sequences appear in the <code>all_sequences</code> view when connected with the read-only user.</p>
  
  <p>However this means that the read-only user is able to do</p>
  
  <pre><code>SELECT my_sequence.NEXTVAL FROM DUAL;
  </code></pre>
  
  <p>which is a no-go for our situation (after all, the read-only user shall not be able to modify anything, not even sequences).</p>
  
  <p>Is there another way for retrieving the sequences which does not allow selecting <code>NEXTVAL</code>?</p>
  
  <hr>
  
  <p>[Edit:]</p>
  
  <p>If I do</p>
  
  <pre><code>SELECT DISTINCT sequence_owner FROM all_sequences;
  </code></pre>
  
  <p>I get the following list:</p>
  
  <pre><code>SEQUENCE_OWNER                 
  ------------------------------ 
  MDSYS                          
  DMSYS                          
  OLAPSYS                        
  XDB                            
  SYS                            
  
  5 rows selected
  </code></pre>
  
  <p>After using the <code>system</code> user to do</p>
  
  <pre><code>GRANT SELECT ANY DICTIONARY TO MY_USER;
  </code></pre>
  
  <p>the result stays the same (revoke does not change anything either).
  Granting the <code>SELECT_CATALOG_ROLE</code> instead does not work either.</p>
  
  <p>Granting <code>SELECT</code> on at least one of the sequences however changes the result to include my own schema owner.</p>