topic Re: Qlikview: Row level security implementation in QlikView

Qlikview: Row level security implementation

VishrantiC — Sat, 16 Nov 2024 02:13:00 GMT

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.

Re: Qlikview: Row level security implementation

qliksus — Thu, 17 Oct 2019 09:06:37 GMT

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 ?

Re: Qlikview: Row level security implementation

VishrantiC — Thu, 17 Oct 2019 09:47:45 GMT

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.

Re: Qlikview: Row level security implementation

qliksus — Thu, 17 Oct 2019 10:14:03 GMT

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

Re: Qlikview: Row level security implementation

VishrantiC — Thu, 17 Oct 2019 10:20:53 GMT

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.

Re: Qlikview: Row level security implementation

qliksus — Fri, 18 Oct 2019 04:36:31 GMT

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 .

Re: Qlikview: Row level security implementation

Brett_Bleess — Tue, 22 Oct 2019 20:35:42 GMT

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