| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | Carol Cheung <cacheung(at)consumercontact(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: meaning of "create role" |
| Date: | 2007-06-20 13:58:23 |
| Message-ID: | 009F62EA-B8E9-4D44-B672-ED1CE459C5CD@seespotcode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Jun 20, 2007, at 8:20 , Carol Cheung wrote:
> 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?
> (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?)
For the roles (users) on your system, yes. Though you should have at
least one superuser who has CREATEROLE, otherwise you couldn't create
new roles.
See the docs for more details:
http://www.postgresql.org/docs/8.1/interactive/role-attributes.html
Michael Glaesemann
grzm seespotcode net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2007-06-20 14:00:01 | Re: meaning of "create role" |
| Previous Message | Carol Cheung | 2007-06-20 13:20:44 | meaning of "create role" |