Re: BUG #18183: Unable to grant similar roles after changing user from No inheritance to Inheritance.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #18183: Unable to grant similar roles after changing user from No inheritance to Inheritance.
Дата
Msg-id CAKFQuwbYbBJkAkUXDSF8D3WTJNwL=PT8iMR0LhEP=woperae5Q@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #18183: Unable to grant similar roles after changing user from No inheritance to Inheritance.  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Monday, November 6, 2023, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18183
Logged by:          Riyaz Khan
Email address:      riyaz489.rk@gmail.com
PostgreSQL version: 16.0
Operating system:   Windows
Description:       

DB_name  = test

I have created a new user 't1' and Now I want to grant all permission of my
existing user 'test' to this new user 't1'.

As of v16 whether a role inherits the permissions of another role is controlled by the attributes of the membership grant itself.  The role attribute is now only a default.  But I suggest you start writing your grant commands to explicitly state whether the membership confers inherit and not rely on the default.

David J.

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18184: ERROR: wrong varnullingrels (b) (expected (b 3)) for Var 2/2
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #18183: Unable to grant similar roles after changing user from No inheritance to Inheritance.