Re: has_database_privilege is true?

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: has_database_privilege is true?
Date: 2020-08-23 15:03:35
Message-ID: 40B78792-EE61-44A7-B67F-853D0AF4D315@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Stephen,

> On 23. Aug, 2020, at 16:52, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
>
> If you want has_database_privilege() to return that the user doesn't
> have access due to missing GRANT privileges, yes.
>
> An alternative would be to query against pg_roles and check the
> 'rolcanlogin' privilege/column. Again, a user has to have both in order
> to be able to actually log in.

which I did (see previous post). Thanks very much for clearing that up.

Cheers,
Paul

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-08-23 21:08:16 Re: Row estimates for empty tables
Previous Message Stephen Frost 2020-08-23 14:52:19 Re: has_database_privilege is true?