data level security using section access

[qv_testing]

Hi All,

Please anyone explain data level security

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

[vikasmahajan]

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

[israrkhan]

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

[qv_testing]

Hi khan,

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

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

thanks....

[israrkhan]

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

[khasimvali85]

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.

[vikasmahajan]

refer this Section access on sheet level

Sheet Section Access by Group

Vikas

[krishna20]

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);

[#9]

Please read HIC white paper on section access:

Authorization using a Hierarchy