Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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
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