6 Replies Latest reply: Jun 9, 2015 8:02 AM by amine amine RSS

    droit utilisateur/sections acess

      Bonjour tout le monde,

      est ce qu'on peut interdire aux utilisateurs (sauf admin) de modifier un rapports qlikview via les sections access ? (consultation seule )

      si c'est oui , comment le faire ?


        • Re: droit utilisateur/sections acess
          Massimo Grossi

          from  QlikView help

          Restrictions on QlikView Functionality

          The controls found on the Document Properties: Security page and the Sheet Properties: Security page make it possible to disallow the access to certain menu items and prohibit changes in the layout. If these settings are to be used as a truly protective measure, it is important that the document users are logged in as USER. Anyone logged in as ADMIN can change the security settings at any time.

          A user that has opened the document with USER rights does not have the Security pages in the Properties dialogs.



          I just tried with the attached .qvw, this is the section access

               Section Access;

               LOAD * INLINE [

                   ACCESS, USERID, PASSWORD

                   admin, admin, admin

                   user, user, user



          open the .qvw with the different users (admin, user) to see the difference

          with admin you can open the security tab (menu --> settings --> document properties --> security), edit the script, add sheets, etc....

          with user you can't edit the script, add sheets, etc.....

            • Re: droit utilisateur/sections acess

              thx for your answer Massimo, but i want to know how to deny to other users (not admin) the sheet modification , i know that the security tab is available only for the admin, but :

              1) even if i modify the restriction allowed to users in the security tab (as admin) , this modification is also applicabl for the admin so i have  to modify the security tab each time  when i'm logged as an admin!

              2) i know that qlikview restricts the access to data for users (in the hidden script) , but the repport modification is not forbiden.

              what i want is like to attribute rights to users :

              admin : write , read and modify reports

              others : just read

              thank you

              best regards

                • Re: droit utilisateur/sections acess
                  Massimo Grossi

                  If you open my attached .qvw doc as user (user user) you can modify the report (chart) but you can't save the QlikView doc. The result is you can't modify anything (as user) in the .qvw because you can't save it. I do not know if this meets your request; I do not know any other way to limit the change of charts in .qvw documents (with QlikView desktop).


                  If you open my attached .qvw as admin (admin admin) you can modify script, chart, etc, ....... and save the .qvw.

                  without any previous change in the security tab.


                  This is the behavior I get when I try the attached .qvw.

                    • Re: droit utilisateur/sections acess

                      thank you for your replay , i didn't see your .qvw because i have a personnal edition of desctop but i steel don't know how to change restriction wihout influencing the admin , the pb is that i have to remodify the restrictions when i'm logged as an admin!

                      thank you so much

                        • Re: droit utilisateur/sections acess
                          Massimo Grossi

                          this is my script


                          Section Access;

                          LOAD * INLINE [

                              ACCESS, USERID, PASSWORD

                              admin, admin, admin

                              user, user, user



                          Section Application;


                          Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;




                          if(RecNo()>=65 and RecNo()<=90,RecNo()-64) as Num,

                          Chr(RecNo()) as AsciiAlpha,

                          RecNo() as AsciiNum

                          autogenerate 255

                          Where (RecNo()>=32 and RecNo()<=126) or RecNo()>=160 ;






                          mod(TransID,26)+1 as Num,

                          Pick(Ceil(3*Rand1),'A','B','C') as Dim1,

                          Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,

                          Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,

                          Round(1000*Rand()*Rand()*Rand1) as Expression1,

                          Round(  10*Rand()*Rand()*Rand1) as Expression2,

                          Round(Rand()*Rand1,0.00001) as Expression3;


                          Rand() as Rand1,

                          IterNo() as TransLineID,

                          RecNo() as TransID

                          Autogenerate 1000

                          While Rand()<=0.5 or IterNo()=1;


                          Comment Field Dim1 With "This is a field comment";


                          and this my security tab




                          add a chart, reload, save close and reopen with admin/admin or user/user