Re: BUG #18068: Insufficient permission unless SUPERUSER

From: Ghw <ghw(at)ghwfluffy(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18068: Insufficient permission unless SUPERUSER
Date: 2023-08-25 00:17:27
Message-ID: 18a2a0d956e.e9539b35303165.769488109648739004@ghwfluffy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thank you very much for your prompt reply, that was exactly my issue. Sorry for the false bug report.

For anyone else googling how to grant permissions in docker-entrypoint-initdb.d:

CREATE DATABASE mydb;

CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypassword';

\c mydb

GRANT CREATE ON SCHEMA public TO myuser;

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Zhijie Hou (Fujitsu) 2023-08-25 04:06:16 RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder()
Previous Message Jonathan Zacharuk 2023-08-24 20:23:00 RE: Error when using unquoted identifier that contains the word end in a begin atomic block