Use Rls to control button url

[gdxy]

Hi, 

Assuming I have a table that stores the permission to URL, can I use RLS to control the URL they visit when they press a certain button, i.e. when aaa presses the Report button, he will visit url1, and when bbb presses, he will visit url2? Thank you.

[amitchandak · Accepted solution]

@gdxy , Create a role and have this filter

email = userprinicpalname()

Have visual that has URL to click

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk