Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

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.

Tags (1)
1 Reply
Khan_Mohammed
Honored Contributor II

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

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

  *, NTNAMEHEREUSERNAMEHERE, *, ADMIN

];

* will be wildcard to overlook any value (bypass)