Section Access Issue while reloading the script

[Sai12]

Hi I'm getting this error
Access was denied after reload.check that the user that reloads the script is included in the section access part of the script.

The user that reloads the script is already included in section access table also.

Could anyone help me to find out the solution.

[martinpohl]

check if you noted the side notes like all values in upper syntax

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/man...

[Pertjo]

in your section access you should always have user : 'INTERNAL\SA_SCHEDULER' with access to all '*' 

Then you create a Task in the QMC and load it.  This is the best way.

But, if you don't have access to the QMC task scheduler, then try: 

Give your user full access in the section access by setting a star '*' then try to load it.

[Saurabh_K14999]

Hi,

Try using this section access script and add your domain name in place of  *

Section Access;
LOAD
Upper(ACCESS) as ACCESS, UPPER(USERID) as USERID INLINE [
Access, Userid
Admin, *\abc
User, *\xyz
Admin, INTERNAL\SA_SCHEDULER
];

Section Application;

Hope this works.

Also if it doesn't work for you then send your script for better understanding.

Regards,

SK

[Sai12]

this is my section access script in qlik.

Let vEnv_Fmtd =Chr(39) & vEnv & Chr(39);

Let vUsersDir =Chr(39) & 'S1_USERS_' & vEnv & Chr(92) & Chr(39) ;

Let vAdminDir =Chr(39) & 'NM-FST-QLI\QVADMIN' & Chr(92) & Chr(39) ;

Let vAdminPwd =Chr(39) & 'S@D%78@3' & Chr(39);

Let vAccessUser =Chr(39) & 'USER' & Chr(39);

Let vAccessAdmin =Chr(39) & 'ADMIN' & Chr(39);

Let vPwd =Chr(39) & '#123456' & Chr(39);

Let vSQL1 = '$(vUsersDir) & UserID' & ' as USERID,Email as NTNAME,' & '$(vPwd)' &' as PASSWORD,' & '$(vAccessUser)' & ' as ACCESS,' &
'$(vEnv_Fmtd)' & ' as ENV ' & ', OrganizationID as ORGID resident QLIK_Users';

trace query: $(vSQL1);

Let vSQL2 = ' OrderID as ORDERID,' &
'$(vUsersDir) & AccessUserID' & ' as USERID
resident QLIK_UsersSectionsAccess' & ' where Not isNull(OrderID)';
trace $(vSQL2);

Let vSQL_Admin = ' ' & '$(vAdminDir)' & ' AS USERID, 1000 as NTNAME,' & '$(vAdminPwd)' & ' AS PASSWORD,
' & '$(vAccessAdmin)' & ' as ACCESS,Null() as ORDERID,' & '$(vEnv_Fmtd)' & ' as ENV , Null() as ORGID resident QLIK_UsersSectionsAccess';

[NadiaB]

Hi @Sai12 

By any chance are you trying to convert QlikView app into Qlik Sense?

NTNAME is a legacy QlikView value, USERID should be enough. 

Also verify what was mentioned before that you are including INTERNAL\SA_SCHEDULER

Our documentation for Section Access can be found here:

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/man...