Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please anyone explain data level security
Thanks in Advance...............
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
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
Hi khan,
but i have so many users .......
can i use inline table or any other option...
thanks....
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
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.
refer this Section access on sheet level
Vikas
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);
Please read HIC white paper on section access: