Postgres Pro
Downloads
Home   >   mailing lists

Re: Role Granting Issues in PostgreSQL: Need Help - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Role Granting Issues in PostgreSQL: Need Help
Date
Msg-id 1751263.1725510304@sss.pgh.pa.us
Whole thread Raw
In response to Re: Role Granting Issues in PostgreSQL: Need Help  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Wednesday, September 4, 2024, Muhammad Imtiaz <imtiazpg712@gmail.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

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Role Granting Issues in PostgreSQL: Need Help
Next
From: David Rowley
Date:
Subject: Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN