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