3 ms·
Databases have had table level privileges for decades. Not quite the same but its easy enough to use it for the same purpose.
by collyw 10y ago
Databases have had table level privileges for decades. Not quite the same but its easy enough to use it for the same purpose.
- jacques_chester 10y agoI 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.