topic Security in Qlikview in QlikView

Security in Qlikview

hkg_qlik — Tue, 28 Dec 2010 23:08:38 GMT

Hi,

I want to apply data reduction security.

A User Access Table is already available in the Data Warehouse. The User Access Table gives the flexibility of maintaining a secured and unified security access for all the BI tools.

Now I want to use the same User Access Table from the Data Warehouse to grant access to the end user depending on User Access table.

For example: The User Access Table is as follows:

User_Name: Andy , Group_Name: ABC , Branch_Name: XYZ

How do define the security in Qlikview?

Thanks

Security in Qlikview

suniljain — Wed, 29 Dec 2010 08:45:11 GMT

you can define thus types of securities at script level with the help of section access.

Security in Qlikview

Wed, 29 Dec 2010 10:13:07 GMT

QlikView script is made of Two sections.

The Section application is the normal section used to load informations.

You can add a Section access, and load tables with specific format.

These tables will allow you to manage:

Access rights ( ADMIN, USER)

Values rights ( This user can see only this department, etc ..)

In order to do so you should read the QlikView manual and have a look at Section access chapter.

In case of additionnal help, please post 😉

Rgds,

Sébastien

Security in Qlikview

hkg_qlik — Wed, 29 Dec 2010 18:58:56 GMT

Hi Sebastien,

I got that one right from the Qlikview manual.

But the thing I am trying here is to maintain a external USER_Access_Table in the Data Warehouse itself to dictate the security in Qlikview.

For Example: If I make any change in the USER_Access_Table like change the USER Name, Delete a record or add a new user access record it should automatically link it with the Qlikview security model so I do not have to again define it in the section access.

I hope i am some what clear on the security requirement.

Thanks,

Security in Qlikview

pover — Wed, 29 Dec 2010 20:05:21 GMT

Why don't you just load the user_access table from the DWH into QV? The only column you don't have and need is the ACCESS column that I assume you could add easily in your DWH or make it fixed to 'ADMIN' in the QV script. You would also have to change the column names in the QV Script to make sure you have USERID and make sure that Group_Name is called the same in QV, too.

Then when you make in the DWH access table, QV will be automatically updated after a reload.

Regards.

Security in Qlikview

hkg_qlik — Thu, 30 Dec 2010 01:18:56 GMT

Hi Karl,

Everything seems to work as you suggested. But if I assign any USERID with USER as ACCESS instead of ADMIN in the DWH table it is not allowing the user to open the document.

I am doing anything wrong here.

Thanks,

Security in Qlikview

pover — Thu, 30 Dec 2010 02:09:11 GMT

Section Access can be mighty picky and frustrating to work with sometimes because it requires everything to be capitalized and hates extra spaces. I would try including a upper and trim function in the script to see if it respects USER as ACCESS:

upper(trim(ACCESS_DWH)) as ACCESS

and if that doesn't work just test if the following works to be sure if it is a problem with the data load from the DWH or some configuration in QV.

'USER' as ACCESS

Regards.