Understanding Roles & Grant Options

Поиск
Список
Период
Сортировка
От Carlos Mennens
Тема Understanding Roles & Grant Options
Дата
Msg-id AANLkTinTaMPO7857Oz5O2b9q+Oaxcx4W_4_oC3jKB5hB@mail.gmail.com
обсуждение исходный текст
Ответы Re: Understanding Roles & Grant Options  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I've been reading the documentation and I'm trying to understand what
'GRANT' options make up a 'superuser' in PostgreSQL.

I've got my account which is 'carlos' and then I have an account
called 'jason'. Can someone please explain the difference between the
two roles:

postgres=# \dg
            List of roles
 Role name |  Attributes  | Member of
-----------+--------------+-----------
 carlos  | Superuser    | {it}
 it        | Cannot login | {}
 jason | Create role  | {it}
           : Create DB
 postgres  | Superuser    | {}
           : Create role
           : Create DB

Obviously 'Carlos' is a superuser but what does that exactly entail
beyond CREATEDB & CREATEROLE?

http://www.postgresql.org/docs/8.1/static/app-createuser.html

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

Предыдущее
От: pasman pasmański
Дата:
Сообщение: Cursors WITH HOLD
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Understanding Roles & Grant Options