Discussion board where members can get started with QlikView.
Hello Everyone !!
I am new to qlik. I have created the view and using script imported the data from the project server in qlik report. Now I want to reduce the data based on user role.
example: If user role in project server is Administrator, should have rights to see all the content
if user role in project server is Project manager then should be able to see all the project on which he is manager.
Security restrictions based on Data Base
Follow this thread.
If you want to implement Section Access through DB server. I believe you would need NTNAME to restrict the users & their roles.
If you want to do inline load then the below script might be helpful.
LOAD * INLINE [
EMPLOYEEID, NTNAME, USERNAME, ROLENAME, ACCESS
*, NTNAMEHERE, USERNAMEHERE, USER, ADMIN
*, NTNAMEHERE, USERNAMEHERE, *, ADMIN
* will be wildcard to overlook any value (bypass)