Inherit Superuser Role Help

Поиск
Список
Период
Сортировка
От Carlos Mennens
Тема Inherit Superuser Role Help
Дата
Msg-id CAAQLLO5ZMj_g5o+Xby_99S0p8+nD1rmvk8+WvPRATBxTOxAe7g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Inherit Superuser Role Help
Список pgsql-general
What am I missing here?

postgres=> SELECT current_user;
 current_user
--------------
 carlos
(1 row)

postgres=> CREATE DATABASE carlosdb;
ERROR:  permission denied to create database

postgres=> \du
                                    List of roles
 Role name |                          Attributes
   | Member of
-----------+--------------------------------------------------------------+-----------
 carlos    |
   | {dba}
 chris     |
   | {web}
 dba       | Superuser, Create role, Create DB, Cannot login, Replication | {}
 postgres  | Superuser, Create role, Create DB, Replication               | {}
 web       | Cannot login                                                 | {}

Shouldn't 'carlos' be a superuser based on him being a member of a
role which has createdb and superuser rights granted to it?

--
Carlos Mennens


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Most efficient way to insert without duplicates
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Inherit Superuser Role Help