title: Grant access to all databases and their tables with Postgresql
body: <p>So I've done, </p>
  
  <pre><code>GRANT USAGE ON SCHEMA public TO myuser; 
  GRANT SELECT ON ALL TABLES IN SCHEMA public TO myuser;
  </code></pre>
  
  <p>and even </p>
  
  <pre><code>GRANT ALL PRIVILEGES ON DATABASE mydb1 TO myuser;
  GRANT ALL PRIVILEGES ON DATABASE mydb2 TO myuser;
  </code></pre>
  
  <p>But I'l still getting <code>ERROR:  permission denied</code> errors:</p>
  
  <pre><code>=&gt; select * from language;
  ERROR:  permission denied for table language
  </code></pre>
  
  <p>What I'm missing? </p>
  
  <p>And for <code>GRANT SELECT ON ALL TABLES IN SCHEMA public TO myuser</code>, all three of my current Postgresql databases have SCHEMA called <code>public</code>, what exactly that SQL is granting to? </p>