Dundas / User Level Security

#1

Hi All

We have a set of users who should on be restricted to see the data for a particular region. What is the best way to achieve it in Dundas.

For example I have User1, User 2 , User 3 …
And regions as NA , GCG , AP
I want User 1 to see only NA Data
I want User 2 to see only AP data
I want User 3 to see everything (all regions)

Note : We are using only one data cube and one de normalized table where we have this entire data.

Thanks in Advance.

Regards
Aditya Dave

#2

Hi Aditya,

I’d recommend looking into a Security Hierarchy as it’s the goto for such requirements.

I’ve created a video showing this topic.
https://www.dundas.com/resources/off-the-charts-tips-from-an-expert/use-row-level-security-filter-data-by-user

And here is the documentation.
https://www.dundas.com/support/learning/documentation/administration-configuration-customization/how-to/using-a-security-hierarchy-to-filter-data-by-user

1 Like