title: Revoke access to postgres database for a role
body: <p>I have created a separate role "newrole" and new schema "newschema" for a certain user that should only execute some stored functions. I have managed to revoke access to schema "public" for the current database.</p>
  
  <p>Logged in as "newrole" I still have access to postgres database like this:</p>
  
  <pre><code>SELECT * FROM pg_user
  </code></pre>
  
  <p>I want to revoke all access to the postgres database and tried following that not work:</p>
  
  <pre><code>REVOKE ALL ON DATABASE postgres FROM newrole
  </code></pre>
  
  <p>When logged in as newrole I can still read the postgres database.</p>
  
  <p>How do I revoke any access to the postgres admin database?</p>
  
  <p>I have searched a long time but not found anything regarding access to the postgres admin database.</p>
  
  <p>TIA,</p>