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?

This is on 8.2.3, btw.


Larry Rosenman           
Phone: +1 512-248-2683                E-Mail: [EMAIL PROTECTED]
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to