Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux