Thomas Kellerer wrote:
> I usually create new databases with an explicit owner which is the
> "application user" that is used by
> the application to connect to the database.
>
> I recently noticed when I do the following:
>
> postgres=# create user arthur identified by 'secret';
> postgres=# cr
Alberto Cabello Sánchez, 08.04.2014 13:05:
>> But I would have expected the owner of the database to be the owner of any
>> "object" that is created during database initialization.
>>
>> Do I have a wrong assumption here?
>
> It seems you do. See:
>
> Why Postgresql Public Schema Is Not Owned B
On Tue, 08 Apr 2014 12:45:29 +0200
Thomas Kellerer wrote:
>
> But I would have expected the owner of the database to be the owner of any
> "object" that is created during database initialization.
>
> Do I have a wrong assumption here?
It seems you do. See:
Why Postgresql Public Schema Is Not
Hello all,
I usually create new databases with an explicit owner which is the "application
user" that is used by the application to connect to the database.
I recently noticed when I do the following:
postgres=# create user arthur identified by 'secret';
postgres=# create database guide owner =