Design question: Should "postgres" own all the db objects?

Поиск
Список
Период
Сортировка
От Andreas
Тема Design question: Should "postgres" own all the db objects?
Дата
Msg-id 4A5A8999.40203@gmx.net
обсуждение исходный текст
Ответы Re: Design question: Should "postgres" own all the db objects?
Список pgsql-general
Hi,

who should own the db objects?
I once read one should not let postgres or any other superuser own the
tables and what not.
Instead one should better create a separate user role with little
privileges to be the owner.
I'm not quite sure why this was abvised. Maybe like not using root for
everyday work.

What is commonly regarded as good design in this issue?

Thanks for your input

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: how drop a role that owns stuff ?
Следующее
От: Andreas
Дата:
Сообщение: How move a referenced table between schemas?