egnlvn.
PPrisma
•Created by egnlvn. on 5/22/2024 in #help-and-questions
Prisma RLS using transactions
Hey guys, I hope to get some help here 🙂
I want to implement RLS using a prisma client extension (as explained here https://github.com/prisma/prisma-client-extensions/tree/main/row-level-security).
This works as expected for the cases where I only query some data without using transactions. However if I use sequential transactions ($transaction([])) it seems to be that only the "outer" transaction (the transaction inside the client extension which intercepts my queries in order to set the RLS parameter) is called but not the "inner" transactions which should be called right after setting the RLS parameter. I don't use interactive transactions and my prisma client version is 5.12.1. Has anyone ever had similar problems?
Thanks in advance 🙂
2 replies