| From: | "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [General] beginner!!! |
| Date: | 2009-12-09 15:44:40 |
| Message-ID: | 4B1FC5E8.1040204@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2009-12-09 15:57:50 | Unix ODBC on SPARC 64 bits |
| Previous Message | John R Pierce | 2009-12-09 15:41:18 | Re: [General] beginner!!! |