Re: CREATE USER and createuser not working the same

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: CREATE USER and createuser not working the same
Date: 2007-09-13 13:53:55
Message-ID: 7879.1189691635@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <stephane(dot)schildknecht(at)postgresqlfr(dot)org> writes:
> It seems the shell command createuser and the SQL CREATE USER don't act
> the same way,

They aren't really claimed to. But the difference you point to is
irrelevant, since a superuser has createrole and createdb privilege
(and every other privilege) independently of what those columns say.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2007-09-14 02:43:23 Re: BUG #3486: doc bug - Preventing transaction ID wraparound failures
Previous Message Darren Ginter 2007-09-13 12:03:44 BUG #3609: Failed to create process for initdb