Row Level Security - hide table for all but named users
I have a model and I want to hide one table from all users except for a few named users. Is there a way that I can create a role such that named users can see the table, but everyone else (added to the workspace) is prevented from seeing the table. This way if someone is added to the workspace by default they won't see the data from the table.
Thanks for the response. I've set up a role and am able to hide all rows of the table to members of that role. However my I don't wan't to have to add new members to this role. I would like an exception based role. Therefore if you aren't a member of a role then you will not see the rows of the table, but if you are members of a role then you will see them. It seems the opposite way in which it usually works.
Thanks for trying to help, unfortunately I don't think that I've accurately described my problem. So whilst what you say is very valid it isn't a solution to my question. I keep reading the documenation and the blogs. Cheers Ed