3 ms·
> does this also work for tables where the GRANT hides certain columns from different users? Yes, it does! Any columns that are not selectable by the user's ro
by oliverrice 5y ago
> does this also work for tables where the GRANT hides certain columns from different users?
Yes, it does! Any columns that are not selectable by the user's role are hidden from the JSON `response` and `old_response` keys and are not allowed for user defined filtered.
Here is where the columns are checked to see if they are selectable
https://github.com/supabase/walrus/blob/f030688d9d94520b916db92b4a92940bc0172155/sql/walrus--0.1.sql#L315 https://github.com/supabase/walrus/blob/f030688d9d94520b916d...
And here is there they are filtered out
https://github.com/supabase/walrus/blob/f030688d9d94520b916db92b4a92940bc0172155/sql/walrus--0.1.sql#L394 https://github.com/supabase/walrus/blob/f030688d9d94520b916d...
- SahAssar 5y agoThanks! Seems like you guys thought of everything :)