Re: Role Granting Issues in PostgreSQL: Need Help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Muhammad Imtiaz <imtiazpg712(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Role Granting Issues in PostgreSQL: Need Help
Date: 2024-09-05 04:25:04
Message-ID: 1751263.1725510304@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> On Wednesday, September 4, 2024, Muhammad Imtiaz <imtiazpg712(at)gmail(dot)com>
> wrote:
>> replication_expert | Cannot login

> Those are not permissions, they are attributes, and attributes are not
> inherited.

Specifically: the NOLOGIN attribute on a role is a hard block on
logging in with that role, independently of any and every other
condition.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2024-09-05 04:48:36 Re: relfilenode statistics
Previous Message David G. Johnston 2024-09-05 04:14:28 Re: Role Granting Issues in PostgreSQL: Need Help