topic Re: Data Security in Qlikview in QlikView

Data Security in Qlikview

Fri, 19 Apr 2013 06:42:21 GMT

How do I get the credentials (e.g. email address) of the user accessing the qlikview document?

Here is my scenario:

We have a qlikview report that displays data by countries

User A has access to countries a, b, c

User B has access to countries d, e, f

User C has access to countries a, e, g

When user A access the qlikview report he should only see data rows for countries a, b, c

When user B access the qliview report he should only see data rows for countries d, e, f

Same with user C.

All of these users can access the report simultaneously, so it is important that we get the credential of each user accessing the report.

We have the full qlikview setup: server, publisher and user accessing from browser.

The user is authenticated through ActivIdentiy (using the user's email address).

We are not allowed to use macros.

Any help is greatly appreciated.

Thank you very much.

Re: Data Security in Qlikview

Fri, 19 Apr 2013 08:10:41 GMT

Hey,

With the function OSuser() you can see which user is logging in.

Your problem sounds like something you can solve with section access.

Search the community for section access and you should be albe to find it.

Or check this topic for example:

http://community.qlik.com/thread/37211

Hope this helps,

gr.

Frank

Re: Data Security in Qlikview

nirav_bhimani — Fri, 19 Apr 2013 08:31:57 GMT

Hi,

See the attachment.

Use user name as following and password also same

ADMIN, ADMIN

USER, USER1

USER, USER2

Regards,

Nirav Bhimani

Re: Data Security in Qlikview

Fri, 19 Apr 2013 09:03:02 GMT

You can resolve this issue by using Section Access, see attached document.

The attached version is a simple version and checks for the NTNAME Windows NT Domain user (user login) to see if the user can access the report.

The data is then reduced by the DR_COUNTRY (country) field.

Open the attached and change my NTNAME to yours. Save the document and then make a backup. Once the backup has been created go to Settings > Document Properties > Opening > Select "Initial Data Reduction Based on Section Access".

Reload the document and save and close. Reopen the document and you will see the data has been reduced to the countries you have specified.

A word of warning all the data in Section Access has to be UPPER case!

Re: Data Security in Qlikview

Fri, 19 Apr 2013 09:18:23 GMT

Thank you for the reply, but I think OSuser will give me the user who is logged in to the server (which most probably is a system user ID). That's not what I need.

I need the credentials of the user accessing/browsing the report. And this user was authenticated through ActivIdentity.

You see, we have a table where all the user authorizations are stored. So, I need to get the credential of the user accessing/browsing the report so I can get his authorization from our authorization table and display the data based on those authorizations.

Re: Data Security in Qlikview

Fri, 19 Apr 2013 09:21:24 GMT

Thank you for the reply. But please see my previous reply frankcrezee

Re: Data Security in Qlikview

Fri, 19 Apr 2013 09:22:14 GMT

Thank you for the reply, but I cannot open the qvw file that you attached eventhough my qlikview is licensed.

Re: Data Security in Qlikview

Fri, 19 Apr 2013 09:39:24 GMT

Oops, forgot to comment out the Section Access!

See attached updated version.

Re: Data Security in Qlikview

Fri, 19 Apr 2013 12:41:50 GMT

Have you tried using OSUser()? Create a textbox with =OSUser() and see what the value is when opening it online.

We are also using a single-sign-on system and when using OSUser() I get the user identity from the authorization table.

gr.

Frank

Re: Data Security in Qlikview

Sat, 20 Apr 2013 12:57:48 GMT

Hi Frank,

I will try your suggestion and will let you know.

Thank you very much for taking the time to reply.

Regards,

Rhea