I’ve done a fair amount of work with MS-SQL, PostgreSQL, and MySQL databases, and one of the things that I always thought was odd was the way that all 3 of them, and presumably Oracle too, have user and permission systems of moderate to high levels of sophistication, yet I’ve never heard of anyone using them. All I’ve developed have been desktop and web apps accessing database servers, and every one of them at every company I’ve worked at has used a single database user with full privileges to everything on the server.
So I’m curious - have any fellow lobsters actually set up a production database server with multiple user accounts with varying levels of permissions over the database tables? Have you ever used features like row and column level security in production? What did you use these features for, and how did it end up working out?