Security in Qlikview

[hkg_qlik]

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

H

[suniljain]

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

[#3]

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

[hkg_qlik]

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,

H

[pover]

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.

[hkg_qlik]

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,

H.

[pover]

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.