Can I only allow viewing some columns in RLS?

Right now, I have two tables.

chat

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

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
      )
      `
    )

  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

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)

Supabase•4y ago•

9 replies

KTibow

Can I only allow viewing some columns in RLS?

Right now, I have two tables.

chat

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

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
      )
      `
    )

  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

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)

Can I only allow viewing some columns in RLS?

Similar Threads

Can I only allow viewing some columns in RLS?

Similar Threads

Similar Threads

Similar Threads