Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data Security in Qlikview

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.

Tags (1)
9 Replies
Not applicable

Re: Data Security in Qlikview

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

nirav_bhimani
Contributor III

Re: Data Security in Qlikview

Hi,

See the attachment.

Use user name as following and password also same

ADMIN, ADMIN 

USER, USER1

USER, USER2

Regards,

Nirav Bhimani

Not applicable

Re: Data Security in Qlikview

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!

Not applicable

Re: Data Security in Qlikview

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.

Not applicable

Re: Data Security in Qlikview

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

Not applicable

Re: Data Security in Qlikview

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

Not applicable

Re: Data Security in Qlikview

Oops, forgot to comment out the Section Access!

See attached updated version.

Not applicable

Re: Data Security in Qlikview

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

Not applicable

Re: Data Security in Qlikview

Hi Frank,

I will try your suggestion and will let you know.

Thank you very much for taking the time to reply.

Regards,

Rhea

Community Browser