topic Re: Security not working in App Development

Security not working

Manni_SM — Tue, 21 Oct 2025 16:48:34 GMT

Hi All ,

am using below script in Qliksense section access but its giving me data not reloaded error.

Section access;
Security:
LOAD * INLINE [
NTNAME,ACCESS,EMPID
AMMS\UK-QLIK-DEV,ADMIN,*
AMMS\UK-QLIK-PRD,ADMIN,*
INDIR-EMP-VIEWER,USER,EMP
INDIR-NONEMP-VIEWER,USER,NONEMP
INFODIR-DEVELOPERS,USER,*
];

Section application;

if i use add

AMMS\USERID,USER,EMP -----------When i add individual user ids its working fine when i add ADgroups its giving below error

data not reloaded am i missing anything?

Re: Security not working

robert_mika — Wed, 22 Oct 2025 07:51:55 GMT

@Manni_SM

Is this is your error?(sort of) Security << 7298a757-5fc1-4d35-9210-26f6b896af13 Lines fetched: 5 Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script. Data has not been loaded. Please correct the error and try loading again.

If you are loading the data you need to be included in SA table

Re: Security not working

Manni_SM — Wed, 22 Oct 2025 09:11:19 GMT

Hi @robert_mika yes all the tables are available and when i add users manually in script its working fine but when i use ADgroups its giving me below error.

Re: Security not working

Manni_SM — Mon, 27 Oct 2025 09:52:10 GMT

Hi @robert_mika @stevedark @rubenmarin @Vegar @marcus_sommer

i tried below section acces code its not working as expected when i add individual user ids its working from when i add ADgroups its not working anything missing?

ERROR : ACCESS DENIED

Section access;
Security:
load * Inline [
ACCESS,USERID,ROLE,EMPLY_IND
ADMIN,AS\234728,*,EMP
ADMIN,"CN=INFODIR-US-APP-GCP-PROD-GRNFLD-BCKNDOPS-DEVELOPERS,OU=USQLIKSENSE,OU=AS,OU=APPLICATIONS,OU=GORUPS,DC=INFODIR,DC=PROD,DC=DCB",*,EMP
USER,AS\234729,*,NON-EMP
];

Section application;

TestData:

load * Inline [
EMPLY_IND,AMT
EMP,1000
NON-EMP,2000
];

Re: Security not working

marcus_sommer — Mon, 27 Oct 2025 11:23:36 GMT

I'm not sure but I think this isn't a valid entry for a user-group:

"CN=INFODIR-US-APP-GCP-PROD-GRNFLD-BCKNDOPS-DEVELOPERS,OU=USQLIKSENSE,OU=AS,OU=APPLICATIONS,OU=GORUPS,DC=INFODIR,DC=PROD,DC=DCB"

Re: Security not working

Vegar — Mon, 27 Oct 2025 11:50:43 GMT

I have the same concern as @marcus_sommer

Make sure that the group name used in Section Access is the same as the group name you see when looking at the i details for the users in the QMC/Users section.

Re: Security not working

Manni_SM — Mon, 27 Oct 2025 11:55:42 GMT

Hi @marcus_sommer even i tried with below Adgroups till no luck

if i use below scirpt only one Adgroup section acess is working (*,ADMIN,Infodir-US-App-GCPQlks-preprod-pbus-developers,EMP) second id group is not working

Section access;
load * Inline [
USERID,ACCESS,ROLE,EMPLY_IND
ADFS\SENSE_SERVER,ADMIN,*,*
INTERNAL\SA_SCHEDULER,ADMIN,*,*
*,ADMIN,Infodir-US-App-GCPQlks-preprod-pbus-developers,EMP
*,USER,Infodir-US-App-GCPQlks-PreProd-Admins-S-D,NON-EMP
];

Section application;

Re: Security not working

marcus_sommer — Mon, 27 Oct 2025 11:57:58 GMT

Maybe there is any typo. One has for example ... preprod ... and the other ... PreProd ...

Re: Security not working

Manni_SM — Mon, 27 Oct 2025 12:00:39 GMT

tried with upper case all the values but still same issue

is there any rule that we need to use in order of fileds like access ,user,role ?

and any issue with Adgroups ?

Re: Security not working

marcus_sommer — Mon, 27 Oct 2025 12:11:39 GMT

The field-order of your examples isn't equally and one is:

ACCESS,USERID,ROLE,EMPLY_IND

and the other:

USERID,ACCESS,ROLE,EMPLY_IND

Beside this I suggest to check again the basic-functionality against users and not groups by specifying different access-rights to EMP and with ADMIN and USER as ACCESS type.

Re: Security not working

Manni_SM — Tue, 28 Oct 2025 04:38:22 GMT

@marcus_sommer i tried all the possible ways but still no luck

thats why you see different order .

is there any setting or something to do while giving Adgroup name in the section access script ?

Re: Security not working

stevedark — Tue, 28 Oct 2025 09:20:35 GMT

Hi @Manni_SM ,

Is this on Cloud or Client Managed, as there are subtle differences.

This article is about Section Access on Cloud:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

I think that the thing you may be missing is that you need separate columns for USERID and for GROUP. If you are adding a line for a group then you need * in the USERID and if you are adding a USERID you need a * in the GROUP.

With the Cloud you need to ensure that your AD groups are pulling through correctly into Cloud. I think that you can also specify groups in the Cloud configuration.

Hope that points you in the right direction.

Steve

Re: Security not working

Manni_SM — Tue, 28 Oct 2025 10:03:27 GMT

Hi @stevedark am using GCP in your link i dont see that any script is working

is there any specific script for GCP section access

Re: Security not working

stevedark — Tue, 28 Oct 2025 10:17:51 GMT

Hi @Manni_SM

When say you are using Google Cloud Platform, is it that you have a virtual Windows machine hosted there, on which you have installed Qlik Sense Client Managed?

If so, the instructions you need are as per an on-premise version of Sense, although it is in the Cloud.

https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

Here it refers to a group as being set up within Qlik Sense, rather than an AD group. This requires that the group pulls through from the User Directory Connector correctly. You can check whether this has happened by going into a security rule (or start creating a new one which you can then cancel) and changing the type to group and then searching for a group in the value box:

I believe that the group name that you find there will work in Section Access, but you need to ensure it is under GROUP rather than USERID.

Hope that helps.

Steve

Re: Security not working

Manni_SM — Tue, 28 Oct 2025 10:31:30 GMT

let me try and update you thanks for suggestion now this is going in right way