Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

section access

Hi,

Let us assume  4 users are there user1,user2,user3,user4.If user 1 login then he can  able to see the particular data in particular time

and user2 login then can able to see some particular data. how we can provide that type of security?

1 Solution

Accepted Solutions
ziadm
Specialist
Specialist

Having DIM1 is the restriction Field

make sure section access all in capital.  Also make sure DIM1 is also capitalize in your Field naming

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME,DIM1

    ADMIN, ADMIN, *, *,*

    USER, USER1, *, *,A

    USER, USER2, *, *,B

    USER, USER2, *, *,C

  USER, Manager,*,*,

];

USER21 will see only A Data where as USER2 see B & C Data

ADMIN will have access to all Data

Regards

Ziad

View solution in original post

2 Replies
ziadm
Specialist
Specialist

Having DIM1 is the restriction Field

make sure section access all in capital.  Also make sure DIM1 is also capitalize in your Field naming

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME,DIM1

    ADMIN, ADMIN, *, *,*

    USER, USER1, *, *,A

    USER, USER2, *, *,B

    USER, USER2, *, *,C

  USER, Manager,*,*,

];

USER21 will see only A Data where as USER2 see B & C Data

ADMIN will have access to all Data

Regards

Ziad

maxgro
MVP
MVP

yes with section access

if you can post some data (or .qvw) maybe someone can better help you

or if you want to try yourself

here an intro

Introduction to Section Access

and other very interesting post

A Primer on Section Access

Basics for complex authorization

and the others blog posts of hic on authorization and data reduction, search in community with

https://community.qlikview.com/search.jspa?q=section+access&type=post