Horton

Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC

Greg Sabino Mullane <htamfids@gmail.com>

View thread View on postgr.es
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Dominique Devienne <ddevienne@gmail.com>
Cc: Andreas Joseph Krogh <andreas@visena.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-general@lists.postgresql.org
Date: 2024-09-12T13:53:02Z
Lists: pgsql-general 
On Thu, Sep 12, 2024 at 9:12 AM Dominique Devienne <ddevienne@gmail.com>
wrote:

> On Thu, Sep 12, 2024 at 3:06 PM Greg Sabino Mullane <htamfids@gmail.com>
> wrote:
> > (Also note that determining if a database or user exists does not even
> require a successful login to the cluster.)
>
> Hi. How so? I was not aware of such possibilities.
> Can you please give pointers (docs, examples) of this?
>

$ psql -U eve
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed:
FATAL:  role "eve" does not exist

$ psql -U postgres -d theater
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed:
FATAL:  database "theater" does not exist

$ psql -U alice -d template1
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed:
FATAL:  password authentication failed for user "alice"

Cheers,
Greg