Forum Discussion

syyyap's avatar
syyyap
New Member
9 years ago
Solved

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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

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.