Design question: Should "postgres" own all the db objects? - Mailing list pgsql-general

From Andreas
Subject Design question: Should "postgres" own all the db objects?
Date
Msg-id 4A5A8999.40203@gmx.net
Whole thread Raw
Responses Re: Design question: Should "postgres" own all the db objects?
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: how drop a role that owns stuff ?
Next
From: Andreas
Date:
Subject: How move a referenced table between schemas?