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

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;