Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data connection to SQL server which have sensitive data.
1. I want to know when I connect using Qlik , will qlik create a copy of this data internally and store it in repository. Is this encrypted or it can be accessed?
2. Can anyone not having access to the SQL DB, but access to app can access this data.
Thank You,
Qlik will store these data internally and they are not encrypted - but you could with Section-Access control who get access to these data.
- Marcus
With section access you could limit either rows as well as columns - to control the columns you need to exclude them within OMIT.
- Marcus
Qlik will store these data internally and they are not encrypted - but you could with Section-Access control who get access to these data.
- Marcus
Thank you for your answer.
With Section Access we can limit the data in rows. Can we limit the columns. Eg. Certain users can see the address, phone no of a person but not all.
Thanks
With section access you could limit either rows as well as columns - to control the columns you need to exclude them within OMIT.
- Marcus
In addition to Marcus' comments, here are some links that will be helpful:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm
Those should come in handy while working upon things. There is also the Scrambling tab in the Settings\Document Properties of the app that contains the sensitive data where you can scramble the values, but that is going to do so for everyone, so if some folks need to see it, that will not work. The OMIT system field in Section Access should be the way to go per Marcus' comments.
Be sure to give Marcus credit as well by using the Accept as Solution button on his post(s) that helped, you can mark more than one response as the solution if multiple ones did help.
Regards,
Brett