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

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Dominique Devienne <[email protected]>
To: Greg Sabino Mullane <[email protected]>
Cc: Andreas Joseph Krogh <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: [email protected]
Subject: Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC
Date: Thu, 12 Sep 2024 16:10:56 +0200
Message-ID: <CAFCRh-_8P=Se_4F5VXn=Z9vc5Dj6+k+xd7HGtt5zsg_=Ltqiyw@mail.gmail.com> (raw)
In-Reply-To: <CAKAnmm+qs8yrviNEbdJf-NLwBiYSxWYN0RHJkcCTjZZVyY8huA@mail.gmail.com>
References: <VisenaEmail.0.81936c517b2d9cfe.191e44de951@origo-test01.app.internal.visena.net>
	<[email protected]>
	<VisenaEmail.1.4f10ceb0099d6ab1.191e48a6946@origo-test01.app.internal.visena.net>
	<CAKAnmm+SrS1=ggcc9qCAXd=uzJWzwH_CciM+aRr-PtDZjrEuRA@mail.gmail.com>
	<CAFCRh-8cornyWJPgKGgLr12d4CMvOEaOOw6yQtJNAqYSC0fYCg@mail.gmail.com>
	<CAKAnmm+qs8yrviNEbdJf-NLwBiYSxWYN0RHJkcCTjZZVyY8huA@mail.gmail.com>

On Thu, Sep 12, 2024 at 3:53 PM Greg Sabino Mullane <[email protected]> wrote:
> On Thu, Sep 12, 2024 at 9:12 AM Dominique Devienne <[email protected]> wrote:
>> On Thu, Sep 12, 2024 at 3:06 PM Greg Sabino Mullane <[email protected]> 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: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  role "eve" does not exist
> psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  database "theater" does not exist
> psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  password authentication failed for user "alice"

Ah silly me, I was thinking of something else.
Sure, "probing" for DB or USER names by attempting connecting is of
course an option.
Thanks, --DD

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC
  In-Reply-To: <CAFCRh-_8P=Se_4F5VXn=Z9vc5Dj6+k+xd7HGtt5zsg_=Ltqiyw@mail.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox