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
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 |