Implementing Security on Qliksense

[lavanyakat]

Hi Qlik,

we have implemented the following script in the "Section Access" part of the data load editor: (... = sensitive information)

However when I added a daily task to load the data, this kept failing with the attached message.

would you be able to help with this?

------------------------------------------------------------------------------

Section Access;

LIB CONNECT TO '...-SQL (...)';

Authorisation:
LOAD
ACCESS,
USERID,
PK_TEAM;

SQL SELECT
[ACCESS],
UPPER([NTNAME]) AS USERID,
[PK_TEAM]
FROM [Qlikview].[dbo].[vw_QV_USER_ACCESS_TAD];
Section Application;

-----------------------------------------------------------------------------------

[mahaveerbiraj]

Hi Lavanya,

When you use groups to reduce data and want to  put reload task in Qlik Management Console, you need add below  code in section access  script.

INTERNAL\SA_SCHEDULER   

Like below 

    Section Access; LOAD * inline

[ ACCESS, USERID, GROUP, REDUCTION, OMIT

USER, *, ADMIN, *,

USER, *, A, 1,

 ADMIN, INTERNAL\SA_SCHEDULER, *, *,   

];