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

hey @avi.f 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 🙂

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

yea. As i said, please see the user roles documentation

I read it, but I dont get how is that implementing row level security...

we don't offer row level security. That's a database feature

I dont think its a database feature, but nevertheless, I get your point. Thanks for your help.

thanks!