Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Arjunarao
Honored Contributor II

Column's data level security

Hi All,

I want to give the access on Job level security of the application.

ADMIN should see all the data of ANALYST,CLERK,MANAGER,PRESIDENT,SALESMAN

USER1 should see the data of ANALYST,CLERK

USER2 should see the data of CLERK,SALESMAN

USER3 should see the data of SALESMAN

Please help me.

Capture.JPG

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Column's data level security

You can use section access. Enable the options Initial Data Reduction Based on Section Access and Strict Exclusion on the Opening tab of the Document Properties window. And add section access tables to your script:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, USER1, USER1

    USER, USER2, USER2

    USER, USER3, USER3

];

LOAD * INLINE [

USERID, JOB

ADMIN,

USER1, ANALYST

USER1, CLERK

USER2, CLERK

USER2, SALESMAN

USER3, SALESMAN

];

Section Application;

EMP:

LOAD * INLINE

[

EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO

7369, SMITH, CLERK, 7902, 1980-12-17 00:00:00.000, 800.00, NULL, 20

7499, ALLEN, SALESMAN, 7698, 1981-02-20 00:00:00.000, 1600.00, 300.00, 30

7521, WARD, SALESMAN, 7698, 1981-02-22 00:00:00.000, 1250.00, 500.00, 30

7566, JONES, MANAGER, 7839, 1981-04-02 00:00:00.000, 2975.00, NULL, 20

7654, MARTIN, SALESMAN, 7698, 1981-09-28 00:00:00.000, 1250.00, 1400.00, 30

7698, BLAKE, MANAGER, 7839, 1981-05-01 00:00:00.000, 2850.00, NULL, 30

7782, CLARK, MANAGER, 7839, 1981-06-09 00:00:00.000, 2450.00, NULL, 10

7788, SCOTT, ANALYST, 7566, 1982-12-09 00:00:00.000, 3000.00, NULL, 20

7839, KING, PRESIDENT, NULL, 1981-11-17 00:00:00.000, 5000.00, NULL, 10

7844, TURNER, SALESMAN, 7698, 1981-09-08 00:00:00.000, 1500.00, 0.00, 30

7876, ADAMS, CLERK, 7788, 1983-01-12 00:00:00.000, 1100.00, NULL, 20

7900, JAMES, CLERK, 7698, 1981-12-03 00:00:00.000, 950.00, NULL, 30

7902, FORD, ANALYST, 7566, 1981-12-03 00:00:00.000, 3000.00, NULL, 20

7934, MILLER, CLERK, 7782, 1982-01-23 00:00:00.000, 1300.00, NULL, 10

];


talk is cheap, supply exceeds demand
8 Replies
MVP & Luminary
MVP & Luminary

Re: Column's data level security

You can use section access. Enable the options Initial Data Reduction Based on Section Access and Strict Exclusion on the Opening tab of the Document Properties window. And add section access tables to your script:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, USER1, USER1

    USER, USER2, USER2

    USER, USER3, USER3

];

LOAD * INLINE [

USERID, JOB

ADMIN,

USER1, ANALYST

USER1, CLERK

USER2, CLERK

USER2, SALESMAN

USER3, SALESMAN

];

Section Application;

EMP:

LOAD * INLINE

[

EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO

7369, SMITH, CLERK, 7902, 1980-12-17 00:00:00.000, 800.00, NULL, 20

7499, ALLEN, SALESMAN, 7698, 1981-02-20 00:00:00.000, 1600.00, 300.00, 30

7521, WARD, SALESMAN, 7698, 1981-02-22 00:00:00.000, 1250.00, 500.00, 30

7566, JONES, MANAGER, 7839, 1981-04-02 00:00:00.000, 2975.00, NULL, 20

7654, MARTIN, SALESMAN, 7698, 1981-09-28 00:00:00.000, 1250.00, 1400.00, 30

7698, BLAKE, MANAGER, 7839, 1981-05-01 00:00:00.000, 2850.00, NULL, 30

7782, CLARK, MANAGER, 7839, 1981-06-09 00:00:00.000, 2450.00, NULL, 10

7788, SCOTT, ANALYST, 7566, 1982-12-09 00:00:00.000, 3000.00, NULL, 20

7839, KING, PRESIDENT, NULL, 1981-11-17 00:00:00.000, 5000.00, NULL, 10

7844, TURNER, SALESMAN, 7698, 1981-09-08 00:00:00.000, 1500.00, 0.00, 30

7876, ADAMS, CLERK, 7788, 1983-01-12 00:00:00.000, 1100.00, NULL, 20

7900, JAMES, CLERK, 7698, 1981-12-03 00:00:00.000, 950.00, NULL, 30

7902, FORD, ANALYST, 7566, 1981-12-03 00:00:00.000, 3000.00, NULL, 20

7934, MILLER, CLERK, 7782, 1982-01-23 00:00:00.000, 1300.00, NULL, 10

];


talk is cheap, supply exceeds demand
prajapatiamar38
Contributor II

Re: Column's data level security

Hello,

I Have made some correction in your application please find below attached.

I hope this is what you want.

Also find the attached excel file below based on this excel i have done section access on data level.

Thanks

help4qv123
Contributor II

Re: Column's data level security

Hi,

Plz find the attachemnt. Login with

Username:admin

pass : admin

check the script for other userID and Passwrd

Not applicable

Re: Column's data level security

HI

USE THE CODE IN SECTION ACCESS SIDE

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, USER01, 123

    USER, USER02, 123

    USER, USER03, 123

];

Section Application;

LOAD * Inline [

USERID,JOB

USER01,ANALYST

USER01,CLERK

USER02,SALESMAN

USER02,CLERK

USER03,SALESMAN

];

IT WILL HELP U TO COM PLEAT YOUR  REQURIMENT

THANK YOU

Not applicable

Re: Column's data level security

Really useful Question and answers, thanks all.

Arjunarao
Honored Contributor II

Re: Column's data level security

Hi All,

I am implementing this and let you know soon.

MVP & Luminary
MVP & Luminary

Re: Column's data level security

Hi,

Check this links

Authentication and Authorization in Qlikview

Hope it helps you.

Regards,

Jagan.

Arjunarao
Honored Contributor II

Re: Column's data level security

Many thanks to gwassenaar and all.