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.

original
Sort:hotnewtop