Section Access Qlik Sense SaaS

[EndreNTillung]

Hi,

Is it possible to use wildcards in the field User.Email for Section Access in Qlik Sense Saas?

For example, is it possible to grant access to every person that has an email ending with "@123.com", without having to type out every single email in Section Access? What I want is something like this:

Section Access;
LOAD * INLINE [

ACCESS, USERID, USER.EMAIL, REDUCTION

USER, *, *@123.com, A

USER, *, *@abc.com, B

];

So emails ending with "@123.com" has access to "A" and emails ending with "@abc.com" as access to "B".

Regards,

Endre

[Dalton_Ruer · Accepted solution]

No the wildcard is simply used for all instead of identifying the email addresses. Like ALL authenticated users. 

If you aren't using the Qlik Identity Provider for your IDP, and aren't in Qlik Cloud Business you could utilize the GROUP field. Simply put all 123.com users in Group 1 and abc.com users in Group 2. 

If you have access to your user list, meaning you know all users and their emails, you can populate the Section Access stuff on the fly from a table that has it. So you would generate all users with A and B etc. 

[jp_golay]

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, and Reverse Engineer existing section Access a time saving for simple cases.

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