On Wednesday, August 23, 2023, PG Bug reporting form <
noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 18068
Logged by: Thaddeus Fuller
Email address: ghw@ghwfluffy.com
PostgreSQL version: 15.4
Operating system: Ubuntu 22.04 / Docker
Description:
CREATE DATABASE ${PGDATABASE};
CREATE USER ${PGUSER} WITH ENCRYPTED PASSWORD '${PGPASSWORD}';
GRANT ALL PRIVILEGES ON DATABASE ${PGDATABASE} TO ${PGUSER};
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO ${PGUSER};
You haven’t connected to the newly created database yet so the within database grants aren’t affecting the newly created database.
David J.