Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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