Dynamic Row Level Security using Email

[newgirl]

Hi!

I usually use a static RLS and recently, I would like to try dynamic RLS. Below are the tables I made for a sample and the roles I created.

However, after trying the roles, it doesn't seem like it's working even though I tried to follow the tutorials. 

The expectation is that if I use danakatrina.XXX@XXX.com, I should only be able to see data tagged to Michael Co.

I would like to ask some inputs on what portion I'm doing wrong.

Thank you

[amitchandak · Accepted solution]

@newgirl , also click on manager role on the second last screen.

[newgirl]

Thanks, @amitchandak ! It worked now