| From: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
|---|---|
| To: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
| Cc: | Andreas Joseph Krogh <andreas(at)visena(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC |
| Date: | 2024-09-12 13:53:02 |
| Message-ID: | CAKAnmm+qs8yrviNEbdJf-NLwBiYSxWYN0RHJkcCTjZZVyY8huA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 12, 2024 at 9:12 AM Dominique Devienne <ddevienne(at)gmail(dot)com>
wrote:
> On Thu, Sep 12, 2024 at 3:06 PM Greg Sabino Mullane <htamfids(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2024-09-12 13:58:53 | Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC |
| Previous Message | Dominique Devienne | 2024-09-12 13:45:01 | Re: Backward compat issue with v16 around ROLEs |