From: Michal Seidl <michal.seidl@gmail.com>
To: pgsql-admin@postgresql.org
Subject: REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC
Date: Fri, 12 Nov 2010 01:34:27 +0100
Message-ID: <4CDC8B93.7070705@gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michal.seidl@gmail.com
Subject: Re: REVOKE ALL ON SCHEMA pg_catalog FROM PUBLIC
In-Reply-To: <4CDC8B93.7070705@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox