Re: CREATE USER and pg_user

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CREATE USER and pg_user
Дата
Msg-id 7731.1123857710@sss.pgh.pa.us
обсуждение исходный текст
Ответ на CREATE USER and pg_user  ("William ZHANG" <uniware@zedware.org>)
Список pgsql-hackers
"William ZHANG" <uniware@zedware.org> writes:
> Why not change the option "createuser" to "superuser",

Backwards compatibility with existing dump files.

> or do something to make is easier to understand?

See
http://developer.postgresql.org/docs/postgres/sql-createrole.html

SUPERUSER
NOSUPERUSER
    These clauses determine whether the new role is a "superuser", who can override all access restrictions within the
 database. Superuser status is dangerous and should be used only when really needed. You must yourself be a
superuserto create a new superuser. If not specified, NOSUPERUSER is the default. 
 

...

CREATEUSER
NOCREATEUSER
    These clauses are an obsolete, but still accepted, spelling of SUPERUSER and NOSUPERUSER. Note that they are    not
equivalentto CREATEROLE as one might naively expect! 
 
        regards, tom lane


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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: obtaining row locking information
Следующее
От: Mark Wong
Дата:
Сообщение: Re: data on devel code perf dip