Revoke access to postgres database for a role
<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>