REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC - Mailing list pgsql-admin

From Michal Seidl
Subject REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC
Date
Msg-id 4CDC8B93.7070705@gmail.com
Whole thread Raw
Responses Re: REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Hello,
I would like to set up database as private as much as possible. The
basic problem is that default access for 'PUBLIC' allows any user to get
information about other existing databases, users, schemas, tables etc.

I think of something like
REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC
REVOKE ALL ON SCHEMA information_schema FROM PUBLIC

but I am not sure about consequences and I did not find any useful
information in manual.

Thanks Michal

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: issue with 9.0 1 slave becomes master with new timeline
Next
From: "Joshua D. Drake"
Date:
Subject: Re: REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC