News for hackers. Stuff that matters.
Re:Implementing system-versioned tables in Postgres by chasd00 on Wednesday February 07, 2024 @09:02AM (#39288652)
I see this “system user” all the time in large integrations projects. It is indeed simpler and many times works just fine but it sure is nice to have something like a “run-as” capability so the far side system can apply user specific security policies based on who is accessing the system vs only the system user profile/role.
Re:Implementing system-versioned tables in Postgres by pdimitar on Wednesday February 07, 2024 @10:12AM (#39289498)
The run-as thingy is done at application level. I didn't find it hard to plug into my maintained apps' logic to insert audit log entries like that (you have access to the currently signed-in user anyway).