Larry Rosenman wrote:
> Greetings,
> I think I found a bug, or at least a POLA violation. At work, I created
> a user that is NOT a superuser, nor can that user create databases. When I
> did a create database foo owner bar, all the schemas are set to be owned by
> the superuser that created the database, not the database owner.
>
> Shouldn't everything that is in the DB be owned by the purported owner?
Right. This is on TODO:
%Set proper permissions on non-system schemas during db creation
Currently all schemas are owned by the super-user because they are copied from
the template1 database.
I note it is marked with a %, but it's clearly not easy at all.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
