section access in order to reduce/restrict data based on roles

Anonymous — Fri, 21 Dec 2012 21:21:11 GMT

I have a dataset loaded into QV that has full data for the entire workforce since 2003. I want to give individual users within their affiliations access to THEIR history and THEIR history ONLY.

New roles have been created to drive this security:

Sample Affiliation roles
HDW^HRA^TUB^Comp^BUS
HDW^HRA^TUB^Comp^SPH

Sample Empl_Type roles
HDW^HRA^TUB^Comp^EmplAll
HDW^HRA^TUB^Comp^EmplStaff

Within the dataset, there is a field called “Access_Affiliation” and another called “Access_Empl_Type.”

HERE IS WHAT I WOULD LIKE:

1. user needs two roles (one Affiliation role and one Empl_Type role) to see this section.
2. The specific role will drive specific access

a. somebody with the roles below should be able to see only SPH affiliation for all employee groups.
                HDW^HRA^TUB^Comp^SPH
                HDW^HRA^TUB^Comp^EmplAll
b. somebody with the roles below should be able to see the BUS affiliation and staff only.
                HDW^HRA^TUB^Comp^BUS
                HDW^HRA^TUB^Comp^EmplStaff

I think I need to add a LOAD * INLINE statement like this, but it doesn’t work:

LOAD * INLINE [
RightsGroup, Access_Affiliation
HDW^HRA^TUB^Comp^BUS, BUS
HDW^HRA^TUB^Comp^SPH, SPH
]

LOAD * INLINE [
RightsGroup, Access_Empl_Type
HDW^HRA^TUB^Comp^EmplAll, All
HDW^HRA^TUB^Comp^EmplStaff, Staff
]

Re: section access in order to reduce/restrict data based on roles

hic — Sat, 22 Dec 2012 16:51:40 GMT

You need to create an Authorization key that links the Section Access with the data. This single key must contain information from both Affiliation_role and Empl_Type. Further, it must be able to handle generic keys, e.g lines like {Affiliation_role=specific; Empl_Type=Any}.

Read http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization which is similar to what you want to do.

HIC

Re: section access in order to reduce/restrict data based on roles

Anonymous — Sat, 22 Dec 2012 20:33:45 GMT

topic Re: section access in order to reduce/restrict data based on roles in QlikView

section access in order to reduce/restrict data based on roles

Re: section access in order to reduce/restrict data based on roles

Re: section access in order to reduce/restrict data based on roles