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
--