title: Oracle - privileges to get metadata from server
body: <p>What minimum privileges my user needs to get metadata (name of tables, columns, functions, etc.) from oracle server?</p>
  
  <p>I need to select from:</p>
  
  <pre><code>dba_segments
  dba_users
  all_tables
  all_tab_comments
  all_views
  all_procedures
  all_source
  all_tab_columns
  all_col_comments
  all_indexes
  all_ind_columns
  all_constraints
  all_dependencies
  all_cons_columns
  </code></pre>
  
  <p>Edit:</p>
  
  <p>I changed conception. Now I need select from table with prefix <strong>dba</strong>% (for example dba_tables, dba_views, etc.).</p>
  
  <p>What minimum privileges I need?</p>