Security level on downdrill and filter possibilities

[Anonymous]

Hi!

Is it possible to give different users different rights for filter and downdrill possibilities?

I know the security level on data, but that is not enough. 

Example: we show revenue of supermarkets

- user A can see the total revenue in a country 

- user B can see the total revenues of supermarkets (within a country)

- user C can see the revenues of supermarkets in a specific category

Hence, user A&B can not see revenue of supermarket X in category Y of country Z. User B only sees revenue of supermarket X  and user A can only see the total revenue of country Z.

[henriquesilveir · Accepted solution]

@Anonymous hello, it's possible, but for this you must create a strutucre to made it possible using RLS.

Example:

Company | user | Market

1                  A       A

1                  B       A

2                  C       B

1                  D      A

i recommed you to use dynamic RLS to do this, take a look is this blog probally it well help you!

https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/

let me know!