Access Control

[pooja_sn]

I need to implement Aunthorization in qlikview.

Our data contains few Regions and Businesses under each Region. User access should be restricted to limited Region and Businesses.

Eg. User ABC should be able to access LONDON,NEWYORK Region and Retails and Finance Business under these two regions.

I am willing to use OSUSer() as logged in user as our application will be accessed using browser.

How this can be achieved?

[MK_QSL]

Use Section Access in your Application.

QlikView Section Access Examples

Introduction to Section Access

Data Reduction Using Multiple Fields

[awhitfield]

Hi Pooja,

sounds like you need to implement SECTION ACCESS within you QVW. Check out the following to get you started in the right direction:

https://community.qlik.com/docs/DOC-1853

HTH

Andy

[florentina_doga]

use section acces like this

facturi:

LOAD agent as AGENT,

     regiune as REGIUNE,

     valoare

FROM

source;

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, AGENT, REGIUNE

admin,admin,admin1,*,*

USER, user1, user11, 'A1',*

USER, user7, user71, 'A1','B2'

USER, user2, user21, 'A2','B3'

USER, user3, user31, 'A3','B1'

USER, user4, user41, 'A4','B2'

USER, user4, user41, 'A4','B2'

USER, user5, user51, 'A5','B3'

USER, user6, user61, 'A6','B1'

];

Section Application;

[pooja_sn]

Hi Florentina,

As users will be accessing this application using browsers , a prompt is already displayed which takes domain id and password as login Credentials.

Is there any way to use same credentials for access control?

[krishnacbe]

Hi Pooja,

You can use the NTNAME instead of USERID. so that user don't want to enter the credentials again.

[pooja_sn]

I tried below script which isn't working. According to Access rights specified below Is hould get Access to Division '01' only ,but I am able to see all data. Any suggestions?

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, DIVISIONID
USER, MYDOMAIN\MYUSERNAME, 01

];

SECTION APPLICATION;
[Division Table]:
LOAD * INLINE [
DIVISIONID, description
01, bird-
02, food
];

[avinashelite · Accepted solution]

Have to checked the Initial data reduction option ???

Go to Document properties > Opening > check > Initial data reduction on opening option

and

make sure both the section application and section access columns should be in caps

[pooja_sn]

Yes. that worked . Thanks

[avinashelite]

cool, if you have got the answer please mark the correct answer and close this thread