From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | public schema owner for newly created database |
Date: | 2014-04-08 10:45:29 |
Message-ID: | li0k09$15f$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 = arthur;
Then when running \l I do see that the new database is owned by arthur.
However wenn I connect to the database and use \dn I see that the public schema is owned by "postgres" (the user that was used to create the database).
Due to the default privileges on the public schema this isn't really a problem and I can always change the owner for the schema anyway.
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?
Regards
Thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Alberto Cabello Sánchez | 2014-04-08 11:05:11 | Re: public schema owner for newly created database |
Previous Message | Albe Laurenz | 2014-04-08 07:30:56 | Re: Initial queries of day slow |