Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
i have four years of data in my data base like 2006, 2007, 2008, 2009. And we have two users like A, B.
My question, i have to give access to two user's alternativly like A access to 2006 & 2008 and B access to 2007 & 2009.
How it is possible?
could you please provide the code.
Thanks & Regards
Ramesh
Use in skript insert section acces inline table with NTName @ the column Year and then enter all kombinations. Last you enter a new row with the serviceuser and no filter in the Year.
Make a copy befor you enter a section access, it is possible to close it vor everyone if the content of the table is not correct.
section access;
Load * inline [
ACCESS, NTNAME, YEAR
ADMIN, DOMAIN\SERVICEUSER1
USER, DOMAIN\USER2,2008
USER, DOMAIN\USER2,2006
USER, DOMAIN\USER2,2007
USER, DOMAIN\USER2,2009
];
section application;
Hi Rameshchetu,
you will find the community has a number of good resources on section access, just use the search option and you will see plenty to help, see a few examples below.
http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access
http://community.qlik.com/docs/DOC-7327
Hope that helps
Joe