|
|
|
|
|
|
by doctor_eval
1264 days ago
|
|
|
I have experimented with mapping application users 1:1 to individual database users, and using SET ROLE at the start of every transaction. I got it working in a PoC, and with the right configuration of roles, this pattern would give you user identity and audit right down to the database itself. Sadly I haven’t pulled it off in production environment yet, but if I ever get the chance to work at this level in an enterprise app again, I’ll definitely do it. |
|
|