Forum Discussion
Dashboards and row level security
Thank you everyone for your answers. So what would you recommend I do if I want to share these charts in a dashboard using an app, but there's some sensitive information that should not be seen by certain users? As far as I'm aware you can only publish one app from a single app workspace, and the content of the app is the same for all users you grant permission to view it? So is the only solution to have two completely separate apps with only one of them containing the sensitive information?
Super UserHi tusmo
I can confirm that when I am using RLS and creating a dashboard that the user will only see the data on the dashboard that is relevant to them.
This will also work in exactly the same manner if you deploy your reports and dashboards via the App experience. There be no need to create multiple apps, you can have all the users within the one App. And as they log in it will display their slice of data.
What I often do is find another user in the Organization who is allowed to view the data, and add them into the RLS to test with to ensure that it is working as expected. This also gives you some piece of mind that it is working.
I think you're receiving too high level of answers here. Lets start with enabling the Row Level security.
You do this from the "Datasets" section of the workspace.
Then select the roles for your row level security and add the individuals or groups you want to be able to access the information.
That will enable the row level security for the Role for the people selected and when one of the people you have enabled views it, it will only show them the information that the Role is allowed to see.
- GilbertQJust a further note, is if you enable RLS and you do not put anyone in the Members area, when a user logs in they will not see any data.
Only when a user is added to a role, will they then see their related data.