I see, thanks for your input. Most of the workflows I worked on involved provisioning one database per app, so I hadn't entertained this angle.
Are there any risks to changing ACL rules on a production database server from a stability perspective?
Are there any risks to changing ACL rules on a production database server from a stability perspective?
i've never seen anything impact postgres stability. they test their code.
i've made DDL changes on live systems; that seems far more concerning than ACLs.