RLS

[Chaimae0]

Hey, I'm dealing with an issue that I've been trying to resolve:

I have a media dashboard, and it includes an advertiser filter on each page. I've set up roles for my dashboard based on a column in my table that corresponds to advertisers. For each page, each advertiser can view the data associated with the roles assigned to them.

However, I also have a page that includes the same filter, and I want clients to be able to access all the data without any restrictions. How can I achieve this?

Thanks, 

[lbendlin]

Sounds like you don't need RLS, but rather need to educate your users how to use the filters. Their filter selections will persist across sessions, but will be private to each report viewer.