CREATE DATABASE foo OWNER bar

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема CREATE DATABASE foo OWNER bar
Дата
Msg-id 002701c78025$5d6fc5e0$184f51a0$@org
обсуждение исходный текст
Ответы 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>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: "Ottó Havasvölgyi"
Дата:
Сообщение: Re: Eliminating unnecessary left joins
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Build-Problem with pgc.c on OSX 10.4