I am working in a company where at present we have like 10 QlikView users but in future we are planning to give access to about 50 to 60 employees. So, what we are thinking is to manage the access for different users to different reports using Centeralized Section Access by making an excel file with credentials of all users.
currently we are using section acess like this on script level
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, GROUP
admin, admin, admin,GROUP3
User, user1, aaa, GROUP1
User, user2, bbb, GROUP2
User,user3, ccc, GROUP3
];
Section Application;
Directory;
LOAD OrderID, OrderDate,
CustomerID, EmployeeID,
Freight
FROM Orders.qvd (qvd);
LOAD * INLINE [
GROUP, SHEET1, SHEET2, SHEET3
GROUP1, 0, 1, 1
GROUP2, 1, 0, 1
GROUP3, 1, 1, 1
];
Can any suggest any Best practice for this or is there anyother way arround other than using Inline to do this?