Postgres Pro
Downloads
Home   >   mailing lists

BUG #18725: "set role" requires "grant connect on database" - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18725: "set role" requires "grant connect on database"
Date
Msg-id 18725-9fd2f5084a8129ad@postgresql.org
Whole thread Raw
Responses Re: BUG #18725: "set role" requires "grant connect on database"
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      18725
Logged by:          itdlz tdba
Email address:      postgresql_tdba@ldbv.bayern.de
PostgreSQL version: 16.6
Operating system:   pgAdmin 4, Version 8.13
Description:

After minor release update to version 16.5 or 16.6 "set role" to role
without "grant connect on database" generates error:

"ERROR:  Benutzer hat das CONNECT-Privileg nicht.keine Berechtigung für
Datenbank »...« 
FEHLER:  keine Berechtigung für Datenbank »...«
SQL state: 42501
Detail: Benutzer hat das CONNECT-Privileg nicht.
Context: paralleler Arbeitsprozess"

It works until version <= 16.4.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Build failure with GCC 15 (defaults to -std=gnu23)
Next
From: Tom Lane
Date:
Subject: Re: BUG #18711: Attempting a connection with a database name longer than 63 characters now fails