Re: [BUGS] CREATE USER and createuser not working the same

2007-09-27 Thread Stéphane Schildknecht
Alvaro Herrera a écrit : > Cédric Villemain wrote: > >> Le jeudi 13 septembre 2007, Tom Lane a écrit : >> >>> =?ISO-8859-1?Q?St=E9phane_Schildknecht?= >>> >> <[EMAIL PROTECTED]> writes: >> It seems the shell command createuser and the SQL CREATE USER don't act the sam

Re: [BUGS] CREATE USER and createuser not working the same

2007-09-21 Thread Alvaro Herrera
Cédric Villemain wrote: > Le jeudi 13 septembre 2007, Tom Lane a écrit : > > =?ISO-8859-1?Q?St=E9phane_Schildknecht?= > <[EMAIL PROTECTED]> 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

Re: [BUGS] CREATE USER and createuser not working the same

2007-09-19 Thread Cédric Villemain
Le vendredi 14 septembre 2007, Cédric Villemain a écrit : > Le jeudi 13 septembre 2007, Tom Lane a écrit : > > =?ISO-8859-1?Q?St=E9phane_Schildknecht?= > > <[EMAIL PROTECTED]> writes: > > > It seems the shell command createuser and the SQL CREATE USER don't act > > > the same way, > > > > They aren

Re: [BUGS] CREATE USER and createuser not working the same

2007-09-14 Thread Cédric Villemain
Le jeudi 13 septembre 2007, Tom Lane a écrit : > =?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> 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 man say : " createuser is a wrapper arou

Re: [BUGS] CREATE USER and createuser not working the same

2007-09-13 Thread Tom Lane
=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <[EMAIL PROTECTED]> 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

[BUGS] CREATE USER and createuser not working the same

2007-09-13 Thread Stéphane Schildknecht
Hi, It seems the shell command createuser and the SQL CREATE USER don't act the same way, unless the documentation says they do. In fact, asking to see the role created with the external command let see that a superuser created that way hase rights of superuser AND 'create role', 'create DB' righ