SupabaseS
Supabase•4y ago
KTibow

Can I only allow viewing some columns in RLS?

Right now, I have two tables.
chat: a table that has chat messages with data like the contents and email of the sender for each message, with a foreign key relation based on the email
schoology_users: a table that has information from an external service, like oauth keys, and the name and profile picture of the person
In order to display the chat message, I use something like
  supabase
    .from("chat")
    .select(
      `
      *,
      schoology_users (
        name,
        profile_picture
      )
      `
    )

I don't want to allow people to view the auth keys for each person anonymously, but the query doesn't work with the anon key once I enable RLS for schoology_users. What should I do here?
(Also feel free to suggest a better title and/or tags, could be my actual solution would be different from what I think)
Was this page helpful?