topic Re: Qs - Section Access - Access Denied in App Development

Qs - Section Access - Access Denied

agarciaguillen — Wed, 02 Aug 2017 14:14:49 GMT

Hello everyone,

Trying to use Section Access in my project i found a problem what i can't solve alone.

When i apply Section Access ( Doesn't matters if is to a USER or ADMIN ), after recharge the app, the user recieve an "Access Denied" to the App.

I follow all of tutorials in QS Wiki, and my own developer book but still show me this message.

Actually i use section access from Excel with this script:

section access;

DATA:

LOAD

"ACCESS",

"USERID",

"GROUP",

"ORGANIZACIÓN VENTA",

"ZONA DE VENTA",

"TIPO MATERIAL",

"SUBTIPO MATERIAL",

"NOMBRE JV",

"VERSIÓN FCST",

"RAMO TIPO"

FROM [lib://DEV_APPS_SALES_CFG/SECTION_ACCESS_TABLE.xlsx]

(ooxml, embedded labels, table is Hoja1);

Section Application;

and inside the excel i have :

The version of my platform is:

My questions are:

I place this script at the total begining of the app. Does i need to put this script after something ?

I need enable some configuration in QMC to use Section Access ?

I need place all field than i have in my data model to use Section Access ?

Re: Qs - Section Access - Access Denied

zhadrakas — Thu, 03 Aug 2017 05:11:11 GMT

Hi Alvaro,

1) there is no ADMIN row in your Section Access Table. You need at least one.

2) try upper(USER_ID) to get everything in Uppercase

to your questions:

I place this script at the total begining of the app. Does i need to put this script after something ?
- thats ok. In Qlikview there was a Hidden Script where you need to put your Section Access code. I dont know if that is the case for Sense too.

I need enable some configuration in QMC to use Section Access ?
- Your Script should work.if your usernames are AD names, make sure that the username is used with domain prefix and this domain is added as "User directory connector" in QMC.

regards

tim

Re: Qs - Section Access - Access Denied

Thu, 03 Aug 2017 07:18:12 GMT

Hi Alvaro,

just change USERID to Upper(USERID) as USERID, in Section Access, the value of USERID need be upper case.

Regards,

Nina

Re: Qs - Section Access - Access Denied

Anonymous — Tue, 17 Oct 2017 23:28:16 GMT

Section access once granted should always be followed by a reload of the Qvw. The changes will not be update until the reload is successfully completed. Make sure the reload is completed before you check the access after adding user to section access.