topic Re: Can I put the OSUSER() at CSV file when implement access control ? in QlikView

Can I put the OSUSER() at CSV file when implement access control ?

paulyeo11 — Sat, 07 Mar 2020 05:43:44 GMT

Hi All ,

I like to know for section access control script , it is possible to save in CSV file ? So that the IT Staff who maintain the Qlik QVW don’t need to touch the script. Just need to update the excel file.

i notice most of the people put the section access script at load script.

Paul

Re: Can I put the OSUSER() at CSV file when implement access control ?

Miguel_Angel_Baeyens — Mon, 09 Mar 2020 10:04:50 GMT

Yes, section access table, in terms of loading, it's yet another table. INLINE, FROM, SQL SELECT will work.

You could use an Include variable or a FROM File.csv (txt). But bear in mind that, if for any reason the file is not there, or it is corrupt, or otherwise non-functional, the application will get you locked out and nobody will be able to open it.

That's why I would approach adding some INLINE within the script for ADMIN access (e.g.: developers, QlikView service account), somewhere in the script, then add this CSV file with the non-admin users so if the file is broken, at least the application will still be able to be open.

Re: Can I put the OSUSER() at CSV file when implement access control ?

paulyeo11 — Mon, 09 Mar 2020 10:11:41 GMT

Hi Sir

Thank you very much.

I will try it out.

Paul