Postgres Pro
Downloads
Home   >   mailing lists

CREATE DATABASE foo OWNER bar - Mailing list pgsql-hackers

From Larry Rosenman
Subject CREATE DATABASE foo OWNER bar
Date
Msg-id 002701c78025$5d6fc5e0$184f51a0$@org
Whole thread Raw
Responses Re: CREATE DATABASE foo OWNER bar  (Andrew Dunstan <andrew@dunslane.net>)
Re: CREATE DATABASE foo OWNER bar  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: CREATE DATABASE foo OWNER bar  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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?

This is on 8.2.3, btw.

Thanks!


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

pgsql-hackers by date:

Previous
From: "Ottó Havasvölgyi"
Date:
Subject: Re: Eliminating unnecessary left joins
Next
From: Alvaro Herrera
Date:
Subject: Re: Build-Problem with pgc.c on OSX 10.4