Forum Discussion

Kashinoda's avatar
Kashinoda
Advocate I
8 years ago
Solved

Restrict Column Access with RLS - Almost there but some annoyances.

Hi All,   I have a Sales table which contains a SalesDescription, a small number of these descriptions are confidential - though everyone should be able to see additional sales information (SalesNu...
Need Help
  • Kashinoda's avatar
    Kashinoda
    8 years ago

    Managed to solve it by making the relationship between DimSales and FactSalesConfidential inactive then using a measure to return the description instead.

     

     
Kashinoda's avatar
Kashinoda
Advocate I
8 years ago

Managed to solve it by making the relationship between DimSales and FactSalesConfidential inactive then using a measure to return the description instead.

 

 
AshwiniGutha's avatar
AshwiniGutha
Frequent Visitor
7 years ago

Hi 

I have similar situation where I need to hide column data based on users, but I have to hide whole column data for specific users.

Can you please help how to acheive this