topic Security with Section Access and SingleSignOn in QlikView

Security with Section Access and SingleSignOn

Fri, 24 Apr 2009 16:19:59 GMT

Hello all, I have a seccion access for the security like this: Section Access; [USERID],[PASSWORD],upper(GRUPPE),[ACCESS]; Section aplication;LOAD upper(GRUPPE),SystemUserId; I have 70 users on the application. I create a Table in Excel with USERID, PASSWORD, GRUPPE.
Now I will control the User-Access for the Application with a SingleSignOn or the possibility, that every User have to change the Password after the first login. How can I handle this in QlikView.

Thanks Tanja

Security with Section Access and SingleSignOn

disqr_rm — Fri, 24 Apr 2009 20:34:13 GMT

Please see enclosed. I have put plenty of comments in the script to make itself explainable.
Please open the document with user "admin" and password "1234".
Please pay attention to the Settings -> Document Properties -> Data reduction checkboxes in "Opening" tab

Does this help you?

Thanks

Security with Section Access and SingleSignOn

Mon, 27 Apr 2009 19:16:06 GMT

Thanks, great. It works.

Now I have another question. My application has 4 worksheets. The user should see all data on the first and on the fourth sheet. On the second and third sheet, the user should see only this data on which it rights has. Do you have an idea, how could I handle this?

Thanks for your help

Security with Section Access and SingleSignOn

disqr_rm — Mon, 27 Apr 2009 20:15:36 GMT

Hi Tanja, Thanks for your feedback.

Yes, you may load another field in the "Users" table in the begining which will identify the column ID and value this user should be filtered to. Then, load thie field "WhoAmI" table as well.

In my example, I have added a COUNTRY field as filter criteria. Please see enclosed. I would surely need to have COUNTRY filed in my application data tables (like Sales or Invoice tables, Or customer master). Then all the application data will be reduced to the value of this field, after user sign-on.

Hope this help. And if it does, please verify the answer.

Thanks

Rakesh