BUG #18389: pg_database_owner not recognized with alter default privileges - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18389: pg_database_owner not recognized with alter default privileges
Date
Msg-id 18389-8ad7f569523f579b@postgresql.org
Whole thread Raw
Responses Re: BUG #18389: pg_database_owner not recognized with alter default privileges  (Noah Misch <noah@leadboat.com>)
Re: BUG #18389: pg_database_owner not recognized with alter default privileges  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18389
Logged by:          Marijo Kristo
Email address:      m.kristo@rewe-group.at
PostgreSQL version: 16.2
Operating system:   Debian
Description:

Hello,

i am precreating schemas in template1 database and setting specific
privileges.
When performing "alter default privileges for role pg_database_owner ..."
the group is recognized and the default privilege is also set. No error is
thrown. 

When i create a new database the pg_database_owner role is not working
correctly. I created then the same privilege with specifying the db owner
and then the privilege works. 

Please, check this. Thank you !

Br
Marijo Kristo


pgsql-bugs by date:

Previous
From: ocean_li_996
Date:
Subject: Re:RE: Re:RE: Re:RE: Re:BUG #18369: logical decoding core on AssertTXNLsnOrder()
Next
From: Tom Lane
Date:
Subject: Re: A server crash with a SQL procedure returning a user-defined type on 14.8