Re: CREATE USER and pg_user

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "William ZHANG" <uniware(at)zedware(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CREATE USER and pg_user
Date: 2005-08-12 14:41:50
Message-ID: 7731.1123857710@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"William ZHANG" <uniware(at)zedware(dot)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
superuser to 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 equivalent to CREATEROLE as one might naively expect!

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Wong 2005-08-12 15:43:10 Re: data on devel code perf dip
Previous Message Tatsuo Ishii 2005-08-12 14:10:11 Re: obtaining row locking information