Re: BUG #18068: Insufficient permission unless SUPERUSER

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #18068: Insufficient permission unless SUPERUSER
Дата
Msg-id CAKFQuwYSFjNYt-MmffEbNCnznpyp_8-hT5DCFUtAmFYCkdG4ww@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #18068: Insufficient permission unless SUPERUSER  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #18068: Insufficient permission unless SUPERUSER  (Ghw <ghw@ghwfluffy.com>)
Список pgsql-bugs
Дерево обсуждения
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.
 

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18068: Insufficient permission unless SUPERUSER
Следующее
От: Jonathan Zacharuk
Дата:
Сообщение: Error when using unquoted identifier that contains the word end in a begin atomic block