Section Access - Error message as Access denied

[SwetaSule]

Hi,

I have below code which is for data restriction using section access in Qlik Sense.

I am unable to open application. Getting access is denied error when they are opening application in hub

Please refer to below code and help me to find the reason for above mentioned issue.

Section Access;

Load * Inline [
ACCESS,USERID,REGION
ADMIN,ABC,*
ADMIN,XYZ,INDIA

];

Section Application;
Order:
load *,
Upper(Region) as REGION
Resident OrdersDetails$ ;
Drop Table OrdersDetails$ ;

Thanks in advance

Sweta

[Nicole-Smith]

Are you sure the USERID aligns with what the system is using?  For example, your login could be seen as DIRECTORY\USERID instead of just USERID, so you'll need to make sure the value in your section access matches with what Qlik is seeing it as.  You can double check your values by creating a text object on an already existing application with =OSUser() as a measure.

[PadmaPriya · Accepted solution]

Hello @SwetaSule 

Please follow the below articles:

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Troubleshooting/troublesh...

https://community.qlik.com/t5/Knowledge-Base/How-To-Validate-And-Troubleshoot-Section-Access-Reducti...

Thanks,

Padma Priya

Qlik Support

[jp_golay]

You can now test our new Product SAM that will fully automate Section Access Generation product.

It is no longer necessary to maintain a section access list in Excel or in your database, SAM offers you a complete web application that will secure all your data accesses.

A user can request access to an application with a simple form. Then administrators get notified and can assign the RESTRICTIONS and OMITS from the proposed fields values. User access are generated from on a single line per user, no need to generate tedious cartesian products and include all values to get a "*" value working correctly .

Moreover SAM is able to generate an automatic access section from the authorizations of the QMC, and Reverse Engineer existing section Access a time saving for simple cases.

More details on our website or contact me at jp.golay@ebiexperts.com