Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

manojkumargowda
New Contributor III

Qlikview section access; object id based security

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;