Forum Discussion
Restrict Access to Values
Hi,
How do you restrict access to values based on user permission when they retrieve data from a database.
E.g.
User A - Can retrieve both "Unit" and "Amount"
User B - Only can retrieve "Unit"
Thanks.
One way might be to separate Amount into a different table in the data model. Include enough information like Outlet and Brand so that you can build a relationship back to your main fact table. Then, you should be able to configure an RLS rule that affects only that one table, even if you have to create a column in that table with some keyword like "Restricted" and then build your RLS rule to exclude anything that has "Restricted" in that column.
1 Reply
One way might be to separate Amount into a different table in the data model. Include enough information like Outlet and Brand so that you can build a relationship back to your main fact table. Then, you should be able to configure an RLS rule that affects only that one table, even if you have to create a column in that table with some keyword like "Restricted" and then build your RLS rule to exclude anything that has "Restricted" in that column.