Re: [HACKERS] Superowners
От | Michael Banck |
---|---|
Тема | Re: [HACKERS] Superowners |
Дата | |
Msg-id | 20170126180518.GA31857@nighthawk.caipicrew.dd-dns.de обсуждение исходный текст |
Ответ на | Re: [HACKERS] Superowners (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>) |
Ответы |
Re: [HACKERS] Superowners
|
Список | pgsql-hackers |
On Thu, Jan 26, 2017 at 12:37:44PM -0500, Peter Eisentraut wrote: > On 1/24/17 8:19 AM, Tom Lane wrote: > > What about just saying that the database owner has those privileges? > > After all, the ultimate privilege of an owner is to drop the object > > (and then remake it as she pleases), and the DB owner has that option > > w.r.t. the whole database. So I'm not sure we need to invent a new > > concept. > > A database owner does not necessarily have the permission to create a > new database. Right. Would a "TRUNCATE <database>;" (i.e. empty the database, but don't delete it) make sense/be useful for that maybe? Michael -- Michael Banck Projektleiter / Senior Berater Tel.: +49 2166 9901-171 Fax: +49 2166 9901-100 Email: michael.banck@credativ.de credativ GmbH, HRB Mönchengladbach 12080 USt-ID-Nummer: DE204566209 Trompeterallee 108, 41189 Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
В списке pgsql-hackers по дате отправления: