4 Replies Latest reply: Nov 24, 2010 6:01 AM by Khim Hoe Tan RSS

    Section Access - View all data

      Hi all,

      I'm facing some challenge in setting up section access... hope you guys can help. My question is, how can I setup section access with the configuration below?

      Access, User, Region
      Admin, Admin, All Region
      User, Manager, All Region
      User, Users, Europe

      I tried to use * or blank for All Region, but it doesn't seems to work.

        • Section Access - View all data
          Miguel Angel Baeyens de Arce

          The blank in Region will work if the access for the user is ADMIN and the document is being opened locally (Desktop, not on server, plugin, ajax, etc), because when you open the document on server, all users are given USER access, regardless what they have in section access.

          The use of "*" will only work if the field Region has all possible values you want to see, in your example above, there is only Europe.

          So the only solution I see is to create a new line for users admin or manager for each available regions, then you will be able to use "*" in the other:

           

          STAR IS *; SECTION ACCESS; LOAD * INLINE [ACCESS, USERID, PASSWORD, REGIONADMIN, ADMIN, ADMIN, EUROPEADMIN, ADMIN, ADMIN, AFRICAADMIN, ADMIN, ADMIN, AMERICAADMIN, ADMIN, ADMIN, ASIAUSER, MANAGER, MANAGER, *USER, USERS, USERS, EUROPE]; SECTION APPLICATION;


          Hope this helps.

          • Section Access - View all data

            Use only CAPITAL LETTERS, and blanc instead of *

            ADMIN,ADMIN

            USER,USERS,EUROPE

             

            -Alex

            • Section Access - View all data

              Hi Khim,

              You could use something like following:

               


              Access, User, Region_Acc
              Admin, Admin, All
              User, Manager, All
              User, Users, R_Eur
              Region_TAcc:
              Load 'All' as Region_Acc,
              Region;
              SQL Select Region
              from Regions_Table;
              Load * Inline [
              'R_Eur' as Region_Acc,
              'Europe' as Region];


              The * is usefull, when you have the rest of the Regions assigned at least to one user.

               


              Access, User, Region_Acc
              Admin, Admin, *
              User, Manager, *
              User, Users, Europe
              User, Users2, Africa
              User, Users3, Asian
              User, Users4, America


              Regards.

                • Section Access - View all data

                  Thanks for the suggestion! I modified your code a bit so it fits my requirement:-


                  Access, User, Region_Acc
                  Admin, Admin, All
                  User, Manager, All
                  User, Users, R_EurRegion_TAcc:
                  Load 'All' as Region_Acc,
                  Region;
                  SQL Select Region
                  from Regions_Table;
                  concatenate
                  Load Region as Region_Acc,
                  Region;<pre>SQL Select Region
                  from Regions_Table;

                  The first suggestion will works as well, using similar method (Replace Region_Acc with UserID)

                  Now... my issue is loop when there is 2 tables that require section access. But I guess that will be another topic (modeling) :)