Re: [General] beginner!!! - Mailing list pgsql-general

From Jean-Yves F. Barbier
Subject Re: [General] beginner!!!
Date
Msg-id 4B1FC5E8.1040204@gmail.com
Whole thread Raw
In response to Re: [General] beginner!!!  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
John R Pierce a écrit :
> Jean-Yves F. Barbier wrote:
>> Joana Camacho a écrit :
>> ...
>>
>>> su - postgres
>>> createuser radius --no-superuser --no-createdb --no-createrole -P
>>>
>>                                    ^^^^^^^^^^^^^^
>>
>>> createdb radius --owner=radius
>>>
>>                   ^^^^^^^^^^^^^^
>>
>> There's a slight contradiction...
>>
>
>
> hmm?  no there isn't.   a role can be made the owner a database without
> having the createdb priv himself.  I do this all the time.
>
>    CREATE USER fred WITH PASSWORD 'fredisdead';
>    CREATE DATABASE freddb WITH OWNER fred;

I didn't knew that

--

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [General] beginner!!!
Next
From: Guillaume Lelarge
Date:
Subject: Unix ODBC on SPARC 64 bits