topic Re: data level security using section access in QlikView

data level security using section access

Nagaraju_KCS — Wed, 24 Apr 2013 03:02:08 GMT

Hi All,

Please anyone explain data level security

Thanks in Advance...............

Re: data level security using section access

vikasmahajan — Wed, 24 Apr 2013 06:18:13 GMT

Hi,

Using section access you can provide user login and password to user's

1 If user is pertaining xyz division you you can restrict that user to view his division only.

2 If you want to control module wise security you can give required tabs to users only.

3 Object level security can achive using section access.

4 This can applied as per your bussiness logic and user requirement analysis.

Hope this help you.

Regards

Vikas

Re: data level security using section access

israrkhan — Wed, 24 Apr 2013 08:00:21 GMT

Hi,

try this code,Section access code must be in first tab in script editor.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER, USER, USER

USER, USER1, USER1

USER, USER2, USER2

USER, USER3, USER3

USER, USER4, USER4

];

Section Application;

LOAD * INLINE [

USERID, COUNTRY ......here you can chnge field name, put your field name upon you want to reduce data

USER, North America

USER1, Scandinavia

USER2, South America

USER3, South America

USER4, Europe

];

than go to document properties, opening, make sure the check box { initial data reduction based on section access} is checked...

and search for section access document at comuunity, you will find a very good detail documnt.....

hope this help....

Kind Regards

Khan

Re: data level security using section access

Nagaraju_KCS — Wed, 24 Apr 2013 09:57:24 GMT

Hi khan,

but i have so many users .......

can i use inline table or any other option...

thanks....

Re: data level security using section access

israrkhan — Wed, 24 Apr 2013 18:54:00 GMT

Hi,

Section Access Detail Document link attached..

Have a look on it,then it will be easy for you,

every thing is described step by step, and very easy to understand..

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

in case of any confusion, feel free to ask..

hope this help...

Kind Regards

Khan

Re: data level security using section access

khasimvali85 — Fri, 20 Nov 2015 11:59:28 GMT

Hi Vikas Mahajan,

Using Section Access how can we restrict data only xyz division( 1 point you mentioned above).

share the steps to do process and screen shots its urgent basis.

regards,

Khasim.

Re: data level security using section access

vikasmahajan — Fri, 20 Nov 2015 12:05:47 GMT

refer this Section access on sheet level

Sheet Section Access by Group

Vikas

Re: data level security using section access

krishna20 — Fri, 20 Nov 2015 12:30:57 GMT

Hi,

Please find the below script as well as attached Excel. Hope it helps.

Section Access;

Star is *;

LOAD ACCESS,

NTNAME,

COMP_CODE,

DEPT_CODE,

SH01,

SH02,

SH03,

SH04,

SH05

FROM

(ooxml, embedded labels, table is Sheet1);

SECTION Application;

LOAD //ACCESS,

NTNAME,

//COMP_CODE,

//DEPT_CODE,

SH01,

SH02,

SH03,

SH04,

SH05

FROM

(ooxml, embedded labels, table is Sheet1);

Re: data level security using section access

Fri, 20 Nov 2015 13:01:59 GMT

Please read HIC white paper on section access:

Authorization using a Hierarchy