Postgres Pro
Downloads
Home   >   mailing lists

Re: meaning of "create role" - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: meaning of "create role"
Date
Msg-id 20070620140000.GC10728@a-kretschmer.de
Whole thread Raw
In response to meaning of "create role"  (Carol Cheung <cacheung@consumercontact.com>)
List pgsql-novice
Tree view 
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 by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: meaning of "create role"
Next
From: nhrcommu@rochester.rr.com
Date:
Subject: Simple, Add constraint