Connect to db denied for superuser inherited by group

Поиск
Список
Период
Сортировка
От
Тема Connect to db denied for superuser inherited by group
Дата
Msg-id 9cd041b2b19143758e4f4d8a752421c5@swisscom.com
обсуждение исходный текст
Ответы Re: Connect to db denied for superuser inherited by group  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-admin
Unexpected behavior when trying to connect to a database. Facts:
1) The privilege to connect to the database was revoked from public.
2) User without superuser privileges uses a role with superuser rights (usage confirmed with SHOW current_role.)
3) Unecpected Message: FATAL: permission denied for database "db" DETAIL: User does not have CONNECT privilege.

After granting one of the listed privileges it is working as expected.
1) granting superuser to user 
2) granting connect to db for user
3) granting connect to db to group 
3) granting connect to db to public

What am I missing?  --Michael




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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: restore OIDs
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Connect to db denied for superuser inherited by group