Section Access - OMIT fields for certain users

shelvinpatel — Mon, 30 Apr 2012 12:40:55 GMT

Hi there,

I have added couple of tables to existing application and want to restrict access to those tables for certain users only. I have tried following:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME,SECURITYGROUP1, OMITGROUP1

ADMIN, QVADMIN, ALL

USER, QVUK, UK, group1

USER, QVUS, US, group1

USER, QVINCL,NONE,

];

LOAD * INLINE [

OMITGROUP1, OMIT

group1, Field1

group1, Field2

group1, Field3

group1, Field4

group1, Field5

...

];

User1 and User2 are part of QVUK AD group therefore can see all UK data. Recent addition of OMITGROUP1 to section access has restricted them to view new tables but I only wanted to restrict it for User2 and User1 should see those two tables’ data as well. I can’t do this by users as this is just an example but in reality there are quite a few users who are similar to User1 and User2.

I have created a new security group QVINCL and added User1,just to check whether not having OMIT applied to this, this may allow the required access but didn’t work. See attached file for you to play around. I have added USERUK twice to simulate above scenario where USERUK should be part of QVUK and QVINCL.

Thanks in advance.

topic Section Access - OMIT fields for certain users in QlikView

Section Access - OMIT fields for certain users