Qlikview: Row level security implementation

[VishrantiC]

I have one Qlikview application in which i got request from client that certain data can only be available to certain users.

So i have used row level section access security.But i have one doubt regarding it.

If there are 100 users are using that application and i want 15 users to have access of certain data only.

so for applying security for 10-15 users, i have to create hidden script for it. So is it necessary to write the code about the access of all the 100 users in that script?like 85 users have admin access and other 15 users have specific area of access. 

Is there any other way where i can write about those 15 users only that can use certain data only? because in future there are possibilities to increase the count of users. So every time I need to change the code.

[qliksus]

Are you hardcoding the data access for  15 users  or taking that data access for that 15 users from some table?  Also what should be access of the remaining 85 users should they see everything  ?  

[VishrantiC]

Yes, i am hardcoding the data for 15 users and we can also take data for the same from table or excel.

And yes,other users can see everything.

[qliksus]

Lets assume you have table1 with all the users details (85+15)  and table2 with only the users who have restricted access . The code will be something like 

Table2:

LOAD * INLINE [ 
ACESSS ,USERID , PASSOWRD, NTNAME,DATA
ADMIN , * , * , USER1,DATA1
ADMIN , * , * , USER2,DATA2
.
ADMIN , * , * , UISER15,DATA3 ] ;

CONCATENATE 

Table2:

LOAD  * INLINE [

ACESSS ,USERID , PASSOWRD, NTNAME,DATA

ADMIN , * , * , USER1,*
ADMIN , * , * , USER2,*
.
ADMIN , * , * , UISER100,*]

WHERE NOT EXISTS(NTNAME) ;

[VishrantiC]

Thank you for explanation of the code.

But can you please explain me how this code will work with Qlik application and give the output? As I am new in Qlik.

And one more Question: for applying security, Does it required to enter all the user details into Qlik code?I mean can't we add only those user's details who have restricted access?so except those users,all other users have full access.

[qliksus]

The code works like how Qlikview reacts when you make a selection 

SECTION ACESS ;

Security:

load * inline [

ACESSS, USERID,PASSWORD,NTNAME,REGION

USER,*,*,USER1,AMERICA  

] ;

SECTION APPLICATION;

Realdata:

Load REGION, Zone , Sales from table1 ;

Now ithe field REGION mentioned in Seciton acess will connect to the Field  REGION in the table Realdata and select only the region assigned for that particular user when he opens the dashboard  . thats how the row level security is assingned 

Regarding your second question , you have put all the 100 users who to need acess .

[Brett_Bleess]

Some additional links that should be helpful in your work:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm

I would think the OMIT feature of Section Access may potentially be of use here if the data is in particular fields.

Regards,
Brett