Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Making Sense of Section Access in Qlik Sense

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Dalton_Ruer
Support
Support

Making Sense of Section Access in Qlik Sense

Last Update:

Dec 15, 2016 9:12:24 PM

Updated By:

Dalton_Ruer

Created date:

Dec 15, 2016 9:12:24 PM

Attachments

I recently spent a lot of time digging through materials trying to prepare for a webinar I did today on Section Access in Qlik Sense.

What I found was that while there are a gajillion posts on Section Access in QlikView I found very little detail about Section Access in Qlik Sense. So I whined and belly ached and moaned and pointed fingers and ... just kidding I created some. The attached 13 page document contains what I think is a really good primer on how to implement Section Access in Qlik Sense.

It covers:

How to implement Row Level Security

What an * really does

Explains the difference between USER and ADMIN as an access type

How to handle Section Access via a file or a database instead of just INLINE

How to implement Column Level Security so you can hide PII and PHI

How to implement a combination of Row and Column Level security for when you need Bob to have access to most of the details for Department 42 and Department 44 but he should only see the PII for the employees in Department 42.

Yeah it's that comprehensive. But feel free to comment and add anything that you feel others might need to know. Or describe other use cases and share the code you used.

Disclaimer: I spent about 40 hours researching which included a lot of trial and believe me ... error. So I apologize in advance for the fact that the document isn't "pretty." I simply ran out of time.

Didn't get an engraved invitation to the webinar that I did where I walk through everything in the document and wish to watch it ... you can catch it on demand at:

https://event.on24.com/eventRegistration/EventLobbyServlet?target=reg20.jsp&referrer=&eventid=128282...

Comments
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Excellent document, thanks for taking the time to put it together

ANKITBAJPAILTI
Contributor
Contributor

IS it possible to create section access on qliksense cloud trial version .

 

0 Likes
ANKITBAJPAILTI
Contributor
Contributor

@Dalton_Ruer  IS it possible to implement section access in qliksense cloud trial version.

0 Likes
jp_golay
Partner - Creator II
Partner - Creator II

You can now test our new Product SAM that will fully automate Section Access Generation product.

It is no longer necessary to maintain a section access list in Excel or in your database, SAM offers you a complete web application that will secure all your data accesses.


A user can request access to an application with a simple form. Then administrators get notified and can assign the RESTRICTIONS and OMITS from the proposed fields values. User access are generated from on a single line per user, no need to generate tedious cartesian products and include all values to get a "*" value working correctly .

Moreover SAM is able to generate an automatic access section from the authorizations of the QMC, a time saving for simple cases.

More details on our website or contact me at jp.golay@ebiexperts.com

jp_golay_0-1639987982182.png

 

 

 

 

0 Likes
jp_golay
Partner - Creator II
Partner - Creator II

You can now test our new Product SAM that will fully automate Section Access Generation product.

It is no longer necessary to maintain a section access list in Excel or in your database, SAM offers you a complete web application that will secure all your data accesses.


A user can request access to an application with a simple form. Then administrators get notified and can assign the RESTRICTIONS and OMITS from the proposed fields values. User access are generated from on a single line per user, no need to generate tedious cartesian products and include all values to get a "*" value working correctly .

Moreover SAM is able to generate an automatic access section from the authorizations of the QMC, a time saving for simple cases.

More details on our website or contact me at jp.golay@ebiexperts.com

jp_golay_0-1639987982182.png

 

 

 

 

0 Likes
Version history
Last update:
‎2016-12-15 09:12 PM
Updated by: