Forum Discussion

Power_Guy's avatar
Power_Guy
Frequent Visitor
2 years ago
Solved

Data Masking

Hi All, Need help on this i have a customer table whenever the user with viewer access is rendering the report he should be able to see the table visual with masked customer _address and mobile as i...
  • Anand24's avatar
    2 years ago

    Power_Guy ,
    One suggestion on the top of my mind apart from RLS and OLS is to create a calculated column using userprincipalname().

     

    Masked_Customer_Address = 
    IF( USERPRINCIPALNAME() IN {"[email protected]", "[email protected], "[email protected]"},  "******", [Customer_Address])

     

    Con: For any new users, your IN operator will need constant manual appending of Email IDs if address is to be masked.

  • AllisonKennedy's avatar
    AllisonKennedy
    2 years ago

    Power_Guy You could have a masked address field and a full address field, OLS could hide the unmasked field from non admin users. 

     

    @anand24 has an idea too, though I would flip it around so that the masked address is viewed by default and only users specified as admin see the unmasked.

     

    Note page level security and the idea from anand are not actually security, just workarounds. This means you must be careful how you give permissions on the underlying data model / dataset, as users will still have access to the fields / data.