section access not working properly on AP

[Alex]

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.

[Bill_Britt · Accepted solution]

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
];