Hacker News new | ask | show | jobs
by collyw 3380 days ago
Databases have had table level privileges for decades. Not quite the same but its easy enough to use it for the same purpose.
1 comments

I agree with you.

But if a single process has the single account on the database, how do you partition those permissions? Simply providing multiple logins won't help if you assume hostile code is in your process space.

On the other hand, if each service has its own login, then the database can enforce lowest authority for each. A compromise of one service isn't a game over scenario.

It's the difference between having a single account with the union of all permissions, or disjoint sets.