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 ---------------------------(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 match