Re: meaning of "create role"

Поиск
Список
Период
Сортировка
От A. Kretschmer
Тема Re: meaning of "create role"
Дата
Msg-id 20070620140000.GC10728@a-kretschmer.de
обсуждение исходный текст
Ответ на meaning of "create role"  (Carol Cheung <cacheung@consumercontact.com>)
Список pgsql-novice
am  Wed, dem 20.06.2007, um  9:20:44 -0400 mailte Carol Cheung folgendes:
> Hi,
>
> In PostgreSQL 8.1, when I'm in psql, the command "\du" produces a table
> with one of the columns as "Create role". What does "yes" under "Create
> role" mean?

The user has the right to create a new role.


> (I know that "Create role" seems pretty self-explanatory, but what
> perplexes me is all the users have "no" under "Create role". Does this
> mean that all the users are not allowed to create roles?)

Yes.

I guess, you have at least one user with 'yes', named 'postgres'.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: meaning of "create role"
Следующее
От: nhrcommu@rochester.rr.com
Дата:
Сообщение: Simple, Add constraint