Implementing Security on Qliksense

lavanyakat — Sat, 16 Nov 2024 19:43:37 GMT

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;

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

Re: Implementing Security on Qliksense

mahaveerbiraj — Fri, 08 Nov 2019 14:30:05 GMT

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, *, *,

];