Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jcramirez472
Partner - Contributor III
Partner - Contributor III

SECTION ACCESS WITH AD GROUPS NOT WORKING IN SENSE

Hi All,

The Problem --> Qlik Sense section access is working with USERID, NTNAME, but not ADGROUPS.

Currently we use LDAP to grab users from Active Directory.

EXAMPLE:

ADGROUP SYNTAX --> EXAMPLE1: Call.Center.MGMT

                                      EXAMPLE2: Sales.Account.Team

NTNAME-->  EXAMPLE1: JRAM

                    EXAMPLE2: SREE

USERID SYNTAX --> EXAMPLE1: JRAM

                                  EXAMPLE2: SREE

JRAM is a part of Call.Center.MGMT

SREE is a part of Sales.Account.Team

DOMAIN --> QLIKWORKS

OSUSER() --> QLIKWORKS\JRAM

HERE IS WHAT WORKS AND WHAT DOESN'T WORK:

USERID WORKS:

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, USERID, AREAID, REGIONID, TERRITORYID

ADMIN, QVSENSE

USER, INTERNAL\SA_SCHEDULER

USER, DOMAIN\USERID

USER, DOMAIN\USERID, 01

USER, DOMAIN\USERID, 02, P111111

USER, DOMAIN\USERID, 08, K111111

];

SECTION APPLICATION;


NTNAME WORKS:

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, NTNAME, AREAID, REGIONID, TERRITORYID

ADMIN, QVSENSE

USER, INTERNAL\SA_SCHEDULER

USER, DOMAIN\NTNAME

USER, DOMAIN\NTNAME, 01

USER, DOMAIN\NTNAME, 02, P111111

USER, DOMAIN\NTNAME, 08, K111111

];

SECTION APPLICATION;

ADGROUP DOES NOT WORK:

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, NTNAME, AREAID, REGIONID, TERRITORYID

ADMIN, QVSENSE

USER, INTERNAL\SA_SCHEDULER

USER, DOMAIN\ADGROUP

USER, DOMAIN\ADGROUP, 01

USER, DOMAIN\ADGROUP, 02, P111111

USER, DOMAIN\ADGROUP, 08, K111111

];

SECTION APPLICATION;


Any Ideas?


I have tried UPPER(NTNAME), and also doing all caps on the ADGROUP field without the upper function.


THANKS!

1 Reply
arthur_dom
Creator III
Creator III

Hi! I read briefly on qlik sense help (https://help.qlik.com/sense/2.0/en-us/online/#../Subsystems/Hub/Content/Scripting/Security/sections-...) but cannot find the groupid ...