MIME-Version: 1.0
References: <VisenaEmail.0.81936c517b2d9cfe.191e44de951@origo-test01.app.internal.visena.net>
 <3952715.1726115805@sss.pgh.pa.us> <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>
In-Reply-To: <CAFCRh-8cornyWJPgKGgLr12d4CMvOEaOOw6yQtJNAqYSC0fYCg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Thu, 12 Sep 2024 09:53:02 -0400
Message-ID: <CAKAnmm+qs8yrviNEbdJf-NLwBiYSxWYN0RHJkcCTjZZVyY8huA@mail.gmail.com>
Subject: Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC
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
Content-Type: multipart/alternative; boundary="00000000000006a2770621ec6f3f"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmm%2Bqs8yrviNEbdJf-NLwBiYSxWYN0RHJkcCTjZZVyY8huA%40mail.gmail.com>
Precedence: bulk

--00000000000006a2770621ec6f3f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Sep 12, 2024 at 9:12=E2=80=AFAM Dominique Devienne <ddevienne@gmail=
.com>
wrote:

> On Thu, Sep 12, 2024 at 3:06=E2=80=AFPM Greg Sabino Mullane <htamfids@gma=
il.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

--00000000000006a2770621ec6f3f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Sep 12, 2024 at 9:12=E2=80=AFAM D=
ominique Devienne &lt;<a href=3D"mailto:ddevienne@gmail.com">ddevienne@gmai=
l.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">On Thu, Sep 12, 2024 at 3:06=E2=80=AFPM Gr=
eg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com" target=3D"_blan=
k">htamfids@gmail.com</a>&gt; wrote:<br>
&gt; (Also note that determining if a database or user exists does not even=
 require a successful login to the cluster.)<br>
<br>
Hi. How so? I was not aware of such possibilities.<br>
Can you please give pointers (docs, examples) of this?<br></blockquote><div=
><br></div><div>$ psql -U eve<br></div><div>psql: error: connection to serv=
er on socket &quot;/tmp/.s.PGSQL.5432&quot; failed: FATAL: =C2=A0role &quot=
;eve&quot; does not exist<br><br></div><div>$ psql -U postgres -d theater<b=
r>psql: error: connection to server on socket &quot;/tmp/.s.PGSQL.5432&quot=
; failed: FATAL: =C2=A0database &quot;theater&quot; does not exist=C2=A0<br=
></div><div><br></div><div>$ psql -U alice -d template1</div><div>psql: err=
or: connection to server on socket &quot;/tmp/.s.PGSQL.5432&quot; failed: F=
ATAL: =C2=A0password authentication failed for user &quot;alice&quot;<br></=
div><div><br></div><div>Cheers,</div><div>Greg</div><div><br></div></div></=
div>

--00000000000006a2770621ec6f3f--