3 ms·

I'm surprised nobody is complaining about the complexity of the permission system. I'm a generally smart guy, but setting up default permissions so that new ta

I'm surprised nobody is complaining about the complexity of the permission system. I'm a generally smart guy, but setting up default permissions so that new tables created by a service user are owned by the application user... is shockingly complicated. (I love using Postgres overall, and have no intention of going back to MySQL.)

pyrophane 6y ago
Yes! Postgres permissions are a huge pain to manage! You have to worry about table ownership, grants on existing objects, and default grants on new objects. It is a huge pain to manage.