Additional Grants To SuperUser?

Поиск
Список
Период
Сортировка
От Carlos Mennens
Тема Additional Grants To SuperUser?
Дата
Msg-id AANLkTinN4ZNoQcjxX5qxOZoZTEeAVA6yveSAgEKRiXGH@mail.gmail.com
обсуждение исходный текст
Ответы Re: Additional Grants To SuperUser?
Список pgsql-general
I created a role named 'carlos' which is my current user account with
'superuser' grants but my question is when I look at 'postgres'
account, he has additional grants that I don't understand.

            List of roles
 Role name | Attributes  | Member of
-----------+-------------+-----------
 carlos       | Superuser   | {}
 jmadeline  | Create DB   | {}
 mwilshaw  | Create DB   | {}
 postgres    | Superuser   | {}
           : Create role
           : Create DB

So from what I see above, 'carlos' is a superuser but do I need to
grant him 'CREATEROLE' & 'CREATEDB' rights along with 'SUPERUSER' or
is 'SUPERUSER' by itself good enough?

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

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: set theory question
Следующее
От: Jon Nelson
Дата:
Сообщение: varchar (no 'N') vs. text