Re: Connect to db denied for superuser inherited by group

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Connect to db denied for superuser inherited by group
Дата
Msg-id CAKFQuwZJ3Vf9ftUnr2oK5j+EO+vQ9ZwrhpfM-1oJ8Nwxk81JBw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Connect to db denied for superuser inherited by group  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Fri, Mar 16, 2018 at 7:52 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Stephen Frost <sfrost@snowman.net> writes:
> * Michael.Dietrich@swisscom.com (Michael.Dietrich@swisscom.com) wrote:
>> 2) User without superuser privileges uses a role with superuser rights (usage confirmed with SHOW current_role.)

> Please provide more details about what this step #2 actually means.

If you mean that you did "GRANT superuserrole TO nonsuperuser", this
does not make "nonsuperuser" into a superuser; it merely allows
"nonsuperuser" to use whatever ordinary privileges might've been
granted to "superuserrole".

​IOW, the privileges on the "CREATE ROLE" page are not inheritable - inheritance only applies to privileges that are GRANT'ed

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Connect to db denied for superuser inherited by group
Следующее
От: "Heinemann, Manfred (IMS)"
Дата:
Сообщение: RE: Function search_path