Forum Discussion
Dynamic Row Level Security in a historical environment
There have been a number of questions about Dynamic Row Level Secutiry and I just could not figure out how to make it work in my environment. Apologies this project is too big to replicate: H...
Hi don_writer,
If possible, could you please inform me more detailed information (such as your sample data and your expected output)? You could use simple data to replace your real data and upload it.
In addition, if you want to use RLS, I think you need to create an user table, then create relationship with your other table, and set RLS basedon user table.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Expected output:
- When the CEO looks at the My Group I want them to see everything
- When the Company Lead looks at the Dashboard I want them to see just their company and all its Divisions
- When a Division Head logs in I want them to see just their Division.
What they are is largely manual - there is no field that captures this.