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                      
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to