Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex
Contributor II
Contributor II

section access not working properly on AP

Hi all,

I'm trying to define the section access on my qlikview but it doesn't work once I try in the AP (locked out).
Find attached a sample of my security.qvd (ACCOUNT_KEY fromat is like {...4G5HJ...} all numbers and uppercase letters).

section access;

LOAD upper(ACCESS) as ACCESS,
upper(NTNAME) as NTNAME,
upper(ACCOUNT_KEY) as ACCOUNT_KEY
FROM
[..\..\Security.qvd](qvd)
WHERE 1=1;

section Application;

FACT:
LOAD ACCOUNT_KEY,
...
FROM X;

Any idea what's happening?
If I set myseld as "USER" it works for "*" and restrics correctly for specific ACCOUNT_KEY.

1 Solution

Accepted Solutions
Bill_Britt
Former Employee
Former Employee

Hi,

In looking I don't see anything that looks like an service account.  Also, the only account that you can use * for under Section Access is the service account.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, GROUP
ADMIN, SERVICEACCOUNT, *
ADMIN, administrator, AGRP
ADMIN, bob, CGRP
ADMIN, test, BGRP
ADMIN, mss, BGRP
];
Section Application;

star is *;

LOAD * INLINE [
GROUP, Country
AGRP, *
BGRP, USA
CGRP, Canada
CGRP, France
];

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

1 Reply
Bill_Britt
Former Employee
Former Employee

Hi,

In looking I don't see anything that looks like an service account.  Also, the only account that you can use * for under Section Access is the service account.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, GROUP
ADMIN, SERVICEACCOUNT, *
ADMIN, administrator, AGRP
ADMIN, bob, CGRP
ADMIN, test, BGRP
ADMIN, mss, BGRP
];
Section Application;

star is *;

LOAD * INLINE [
GROUP, Country
AGRP, *
BGRP, USA
CGRP, Canada
CGRP, France
];

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.