User login to app which shows encrypted data

ashmitp869 — Wed, 12 May 2021 02:27:31 GMT

Hi All,

I have a table where user section access details is stored like below for a single user (Say A) :

So when a user (say A) has AUTHID as N and login to see the report.

The report will show the only record from the below table : ( i.e the encrypted version)

I am not sure if its called field level exncrption. For one user two unique created - one with actual data and other with encrypted.

Thanks

Re: User login to app which shows encrypted data

Dalton_Ruer — Wed, 12 May 2021 14:30:12 GMT

If I'm understanding correctly your data source actually has both fields. The Encrypted Value, and the Unencrypted Value. I would be hesitant to try and do anything in a chart or master dimension like "If user rights are n show this field else show that field" because they could simply create their own table, or go to the Selections screen to see the unencrypted values.

I wrote a post many years ago called Making Sense of Section Access in Qlik Sense. https://community.qlik.com/t5/Documents/Making-Sense-of-Section-Access-in-Qlik-Sense/ta-p/1493716

It walks through the case where you simply need to hide certain columns (like unencrypted data) from certain users. But also walks through a case where the end user should see the unencrypted data for certain rows (like their own employees) but not for other rows (other teams employees.)

topic User login to app which shows encrypted data in App Development

User login to app which shows encrypted data

Re: User login to app which shows encrypted data