10 Replies Latest reply: Oct 11, 2012 10:42 AM by Chris Hopkins RSS

    Section Access help

    Chris Hopkins

      Hi everyone.

       

      I am trying to set up section access, it works as expected if i open the document from the desktop client but it doesn't work on the server.

       

      The server version is 11.0.11282.0

      and the client version is  11.11414.0 SR2 64Bit

       

      I have hardcoded 2 ADMIN logins in the Section Access inline load

       

      Userid         Password

      Admin         Admin

      User1         User1

       

      I have attached the files i am using, could somebody please take a look to see what i have wrong.

       

      Thanks

       

      Chris

        • Re: Section Access help
          Miguel Angel Baeyens de Arce

          Hi Chris,

           

          The issue is that the "*" does not mean "all possible values" rather than "all listed (specified) values in section access". In the field "Business Unit Code" that is present in the section access because of the JOIN, some users do not have any value, therefore they do not have access to the document. You either do the JOIN after concatenating both tables or even better, you load the first table without loading the bussiness unit code (note that names must be UPPERcase in section access).

           

          Hope that helps.

           

          Miguel

            • Re: Section Access help
              Chris Hopkins

              Hi Miguel,

              Thanks for the reply.

              I don't understand though.

              The section access works from the desktop client, I don't understand why the join would not work in the server?

                • Re: Section Access help
                  Miguel Angel Baeyens de Arce

                  Chris,

                   

                  The problem is not the JOIN, that will work in the Server as well. The issue is that in Desktop, either "*" or " " (blank) will grant you access to the application if you are an ADMIN or you don't have "Strict Exclusion" checked in your Document Properties, Opening tab.


                  But as a client you are always a USER, even if you hardcoded ADMIN in the ACCESS field in the section access table, therefore there are no valid "*" unless all values for that field have been specified beforehand.

                   

                  Hope that makes sense.

                   

                  Miguel

                    • Re: Section Access help
                      Chris Hopkins

                      Hi Miguel,

                       

                      I can see that you have renamed the field to uppercase and added the same field to the inline table.

                      Everything works from the QV client but NOTHING works from the server.

                      I am confused with the "*" values. do i need to change them in the spreadsheet? I thought having a "*" allows the user to see all values in the dataset? therefore when userid MLOM logs in, he\she would see access region B which means he/she will have access to 5 business unit codes?

                       

                      And i know that section access is uppercase, but if the field itself is lowercase how would that work.

                      i.e. Business Unit code in the data is lower case so how would the UPPERCASE section access field link to it?

                       

                      Thanks

                • Re: Section Access help
                  Chris Hopkins

                  Hi all, could anyone change the examples for me to see what is needed to be done to be fixed?

                  • Re: Section Access help
                    Chris Hopkins

                    hi miguel,

                     

                    I now have it working on the server using the hardcoded userid's and the ones in the spreadsheet, but i cannot get the NTNAME to work.

                    and when i log in successfully (Using an id and password, and from the accesspoint on my local machine), if i type in a text box =osuser() the NTNAME of my server login appears not the NTNAME of my local machine.

                    Any ideas why that is happening?

                    • Re: Section Access help
                      Chris Hopkins

                      Can anyone help with the NTNAME query please?

                      • Re: Section Access help
                        Chris Hopkins

                        does anyone have any ideas why my server ntname is being used in my accesspoint on my local machine? it is stopping section access working.

                        Or am i missing something?