section access - cannot get past this error

[124psu]

hello gurus,

I was able to get my section access to be working perfectly fine through all the great help received from this forum. Now, we decided to store our users in a separate table in our database and decided to pull the data from the db vs. doing an inline in the script. 

--------------- my script -------------

SECTION ACCESS;

LIB CONNECT TO ***

LOAD * INLINE [

ACCESS, USER_ID, ACCESS_ID
ADMIN, domain\andrew,
USER, domain\dummyuser, 1
ADMIN, INTERNAL\SA_SCHEDULER,*,
];

SECTION APPLICATION;

LOAD * INLINE [

ACCESS_ID, DEPARTMENT

1, MARKETING

2, FINANCE

3, ACCOUNTING

4, IT

5, Other

];

---------- end --------------

Pretty much I am making the user "dummy" to only see the value 1 which is Marketing data only. This works fine. Once I brought in the same table but through the database (which stores the exact same data, except I had to create an additional column since an * is considered a varchar).

This shouldn't change anything but please correct me if I am wrong. But upon running the script this is the constant error I get and cannot get past this error. I tried reverting the script to go against the inline and am still getting an error for the script that was once working. I'm a bit lost and reaching out for some additional help or anything you guys may see that I am missing.

error - 

Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.

Thanks a bunch.

[NadiaB]

Hi @124psu 

Please refer to the following information in Qlik Help:

Managing security with section access

I would suggest first change the userid to UPPER CASE all values, then you can check if there is something in the syntax of your code that might be causing a problem.

I have noticed you don't have a REDUCTION value for the ADMIN, that is ok, but please also refer to the following article as the behavior will be different for a user with USER role.

Qlik Sense/Section Access: User with USER rights cannot access the app when no reduction is used in ...

My suggestion would be copy the script from the help site, and then just change users and values.

Hope it helps.

Note: if this response helps to resolve the issue, it will be appreciated if you could mark it as Solved.

We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, product malfunctioning, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/

[124psu]

I've got the section access part to work using the inline method. Now this new issue I just cannot understand how it is behaving and hoping you can shed some light for me. 

When I implement the Section Access using inline in the script (for setting up our users, what data they can see, etc.) it works like a charm. Now, we'd ideally want to set this table up in our database instead of going the inline method. So I created a table that is a replica of the inline data load that includes our users and what they can see. When I bring this table into the section access script, it is then it throws the error of access denied. I reached out to Qliks support and was told I needed to be an admin, which I am. Wondering if you had any ideas on this behavior? 

[NadiaB]

Hi @124psu 

I would suggest to write a new post, sample of the data in the tables, script that is being used, and steps to reproduce.

Kind regards.