Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sebHan
Contributor III
Contributor III

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;

Temp_HistoriskBU:
NoConcatenate
LOAD DISTINCT
HistoriskBU
RESIDENT [Jobdata];

Concatenate([SectionAccessTable])
LOAD
'INTERNAL\SA_SCHEDULER' AS USERID,
'ADMIN' AS ACCESS,
HistoriskBU
RESIDENT Temp_HistoriskBU;

DROP TABLE Temp_HistoriskBU;

Section Application;

Labels (1)
0 Replies