Re: Who should own database?

Поиск
Список
Период
Сортировка
От petrov.boris.v@mail.ru
Тема Re: Who should own database?
Дата
Msg-id 54DA51B1.5000506@mail.ru
обсуждение исходный текст
Ответ на Re: Who should own database?  (Daniel Staal <DStaal@usa.net>)
Список pgsql-novice
On 10.02.2015 18:34, Daniel Staal wrote:
> boris_developer be the owner, as php_script sounds like a web interface,
> and it's usually best not to give web interfaces any permission they don't
> absolutely *need*
You kind of confirming the way I am doing it most of the time. Web is
limited to minimum permissions it particularly uses and the owner is
human user.
 > Or the owner should be a specific account set up just to be the owner
That option also come to mind, and seems logical.
Thank you for considerations.

On 10.02.2015 18:55, David G Johnston wrote:
 > Maybe a bit of over engineering initially but it's worth considering.
 > Slightly simpler is to make the owner role a login role.  In either
 > case client application users should never be able to get owner
 > permissions.
Making LOGIN-less group-role an owner looks complicated to me at least
for now (not even sure I get it completely), but definitely worth
considering. Thank you for sharing.



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

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Who should own database?
Следующее
От: daku.sandor@gmail.com
Дата:
Сообщение: Re: How to get some table entries from backup instance back to production instance