Comment on How do you manage you DB in a docker environment?
bacon_pdp@lemmy.world 6 days ago
One database service but separate databases running inside of the service. Each database has 3 accounts: table_owner (no remote access), proc_owner (only table specific permissions and the owner of all stored procedures; no remote access) and application_account (no table access and only execute permissions on the proc_owner’s stored procedures).
Which means that even if the application is compromised, it can not compromise the database. It can only use approved stored procedures that check their inputs and abort on the smallest deviation from expected inputs.
Croquette@sh.itjust.works 6 days ago
That is way above my database knowledge. I will need to read up on that.
Thanks for the input