https://supertokens.com/ logo
Title
a

avif

11/06/2022, 2:20 PM
Hi, I'm really new to this concept of Auth mechanism, I wonder if its possible to implement row level security without the help of supabase. I have a nodejs app that writes directly to the database and I want to create "Users Group" and allow users from group
A
to read only specific rows. Possible? Thanks
r

rp

11/06/2022, 2:35 PM
hey @avif row level security is a postgresql feature, and not a supertokens specific feature. That being said, we do have user roles feature using which you can implement this. Checkout our docs for user roles 🙂
a

avif

11/06/2022, 2:39 PM
Thanks. Im using mysql as my app database, anyway I dont want to couple auth logic with database vendor. Can you think of a way it can be implemented by writing some helpers in nodejs? Thanks
r

rp

11/06/2022, 2:44 PM
yea. As i said, please see the user roles documentation
a

avif

11/06/2022, 2:58 PM
I read it, but I dont get how is that implementing row level security...
r

rp

11/06/2022, 2:59 PM
we don't offer row level security. That's a database feature
and we are not a database
a

avif

11/06/2022, 3:00 PM
I dont think its a database feature, but nevertheless, I get your point. Thanks for your help.
r

rp

11/06/2022, 3:00 PM
thanks!