Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Assign different rights for „admin“ and „user“ users

Hello everyone,

I was keep searching for an answer in community, but couldn't find it clearly expressed.

I am trying to create different logins on my QlikView application, but I find difficult to do it. Can anyone explain how to do it step by step, cause I am quite new in developing QlikView applications. Thank you in advance.

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: Assign different rights for „admin“ and „user“ users

If you want to prevent editing and reloading the script the you can make a source qvw which you keep for making changes and a copy of that document for distributing. In the source document\document properties you check the prohibit binary load option. In the copy of you replace all loadscript with a binary load statement of the source document. This copy of the original now has no load script to edit and will not reload the source as it is prohibited.

7 Replies
stigchel
Honored Contributor

Re: Assign different rights for „admin“ and „user“ users

You need to look for  Section Access, the ADMIN and USER keywords for the ACCESS field from section Access are system values to restrict access to the document properties in an offline distribution solution and not for assigning any other access rights.

Like said, for assigning different rights look into section Access. You can look in the help (Security) or search the forum. e.g. Here's an introduction to section access:

Introduction to Section Access

Not applicable

Re: Assign different rights for „admin“ and „user“ users

Thank you for your answer, but I couldn't understand one more thing:

i.e. I have two different tabs on my document: Sheet1 and Sheet2

     and I would like to have two different users: user1 and user2

What I would like to do is that user1 could see only Sheet1 and user2 – Sheet2.

What is more, I preffer that user1 can edit script and user2 don't have that option.

How the script should look like?

stigchel
Honored Contributor

Re: Assign different rights for „admin“ and „user“ users

I've made an example for you, see attached, the passwords for opening this document can be found in the pasted script below. The user Administrator can see all and make changes to the document, User1 and User2 can see sheet1 and sheet2 respectively and not make changes

SECTION Access;

LOAD * Inline [ACCESS,USERID,PASSWORD, ACCESSGROUP

ADMIN,Administrator,Admin1,ALL

USER,User1,Access1,SHEET1

USER,User2,Access2,SHEET2

];

Section Application;

star is *;

LOAD * Inline [ACCESSGROUP

'ALL'

'SHEET1'

'SHEET2'

];

Not applicable

Re: Assign different rights for „admin“ and „user“ users

Thanks a lot.

And what about editing or reloading script?

stigchel
Honored Contributor

Re: Assign different rights for „admin“ and „user“ users

If you want to prevent editing and reloading the script the you can make a source qvw which you keep for making changes and a copy of that document for distributing. In the source document\document properties you check the prohibit binary load option. In the copy of you replace all loadscript with a binary load statement of the source document. This copy of the original now has no load script to edit and will not reload the source as it is prohibited.

Not applicable

Re: Assign different rights for „admin“ and „user“ users

By the way, I tried to use your expression (ACCESSGROUP='SHEET2' or ACCESSGROUP='ALL') in all of my sheets and I've got that all the users see the same. Is it bug or?...

stigchel
Honored Contributor

Re: Assign different rights for „admin“ and „user“ users

The section access must have been loaded with in the document properties\opening the option initial data reduction based on section access checked and finally saved. After that you have to close qlikview and reopen it.