Re: [GENERAL] public schema owner for newly created database

2014-04-08 Thread Albe Laurenz
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

Re: [GENERAL] public schema owner for newly created database

2014-04-08 Thread Thomas Kellerer
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

Re: [GENERAL] public schema owner for newly created database

2014-04-08 Thread Alberto Cabello Sánchez
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

[GENERAL] public schema owner for newly created database

2014-04-08 Thread Thomas Kellerer
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 =