Qlikview section access; object id based security

[manojkumargowda]

Hi Guys,

I'm trying to configure Object (or chart) based security in QLIKVIEW using section access. Windows user ids are available in a Database table. Section access to provide access to QVW document for specified users works fine, But object access (For object TX01) is not working. User John should not see the object TX01. I referred Chart Level Access by user, but still not working.

Any help is much appreciated..

USERS:

LOAD

'ADMIN' as ACCESS,

'DOMAINNAME\'&UPPER(WINDOWSUSERID) as NTNAME;

SQL SELECT *

FROM UserAccess;

Section Access;

LOAD *

Resident USERS;

Section Application;

OBJ_ACCESS:

LOAD

NTNAME,

if(NTNAME='DOMAINNAME\JOHN',0,1) as TX01

Resident USERS;