How to grant permssion in qlik report based on role in project server

[#1]

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.

Please suggest.

[MK9885]

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)