Accessing JWT payload to implement row level filters #23042
vishnuramvs29
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I want to display specific data to users based on a value in my table. For instance, I have a table called users with columns username and tenant_id. I need to filter the data shown to the user according to a tenant_id value stored in the JWT payload. How can I access the payload within an SQL query or system property to enforce a policy that only shows relevant data to the users and hides everything else?
Beta Was this translation helpful? Give feedback.
All reactions