Re: has_database_privilege is true? - Mailing list pgsql-general

From Paul Förster
Subject Re: has_database_privilege is true?
Date
Msg-id 40B78792-EE61-44A7-B67F-853D0AF4D315@gmail.com
Whole thread Raw
In response to Re: has_database_privilege is true?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Hi Stephen,

> On 23. Aug, 2020, at 16:52, Stephen Frost <sfrost@snowman.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



pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: has_database_privilege is true?
Next
From: harish supare
Date:
Subject: Substitute Variable in select query