Re: [General] beginner!!!

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

--