Then I would argue for trying to centrally ensure that all roles have INHERIT in... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

WinDoctor on April 29, 2024 | parent | context | favorite | on: Common DB schema change mistakes in Postgres

Then I would argue for trying to centrally ensure that all roles have INHERIT in your DBs. :thinking:

Doing ALTER DEFAULT PRIVILEGES could be another future footgun of it's own.

csnweb on April 29, 2024 [–]

I think you probably don’t want the application user to inherit from the superuser you may use for migrations since some migrations require a superuser.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact