Section access exclude a AD group from current script
Hey! I'm currently working on a section access script. The script is working in filtering the data. However, I would like to allow a/more AD group(s) to have full access, such that that, the people in the AD group(s) can view all the data.
Can anybody help here?
To elaborate, my script is made up of 2 sections:
Section 1) Connect Qlik to an internal database, where BU and EMPLOYEEGUID is loaded whenever an account log-in:
[CustomerTable]: LOAD BU, EMPLOYEEGUID; SQL SELECT BU, EMPLOYEEGUID FROM "Maconomy_comp_Kunder".dbo."T_Maconomy_Employees" WHERE LEN(EMPLOYEEGUID) >0 AND LEN(BU) > 0;
Section 2) Matches the loaded BU with the BU from the data and make section access based upon this:
Section Access;
[SectionAccessTable]: NoConcatenate LOAD 'USER' as ACCESS, 'GLB\' & UPPER(EMPLOYEEGUID) AS USERID, BU as HistoriskBU Resident CustomerTable;