7 Replies Latest reply: Mar 15, 2011 8:49 AM by Thiago Ribeiro RSS

    Section Access/Application: ISSUES

      Greetings!

      Another topic concerning Section Access...

      1st Issue: I have created a XLS file to store the users informations, and do Load it in the SA... everything runs fine, 'till I try to deny everything just for users... my ADMIN user suffers all alterations done to USERS.

      2nd Issue: I tried to link the USERIDs from the security table to my Salesmen field in the report, as well, unsuccesfuly. When the user log in the app, it only must be able to see the info related to it, as if a selection was made and locked, forbidding it to see any info about other salesmen.

      My code to do that, so far, is something like it:

       

      //SECTION ACCESS & APPLICATION

      Section Access;

      AccessPermit:
      LOAD
      ACCESS,USERID,PASSWORD,[GROUP],AREA
      FROM security.xls (biff, embedded labels, table is Users$);

      LEFT JOIN (AccessPermit)
      LOAD
      USERID,
      SALESMAN
      AS SalesManAppField
      FROM security.xls (biff, embedded labels, table is UserInfo$);

      Section Application;
      STAR IS *;



       

      I ran through the refference manual, my QV course matterial, other threads, google, and no answer was found.

      Any light?

      Thx again everyone!

        • Section Access/Application: ISSUES

          Hi,

          For the first issue : have you check the "Admin Override Security" in the security tab ?

          For the second : have you check "Initial Reduction..." in the opening tab ?

          • Section Access/Application: ISSUES
            Oleg Troyansky

            I see 2 issues:

            1. SALESMAN AS SalesManAppField - Section Access can only work with Upper Case Field Names.

            2. The link between the "Security" fields to the "Application" fields needs to happen within Section Application. Something like this:

             


            Section Access;
            AccessPermit:
            LOAD
            ACCESS,USERID,PASSWORD,[GROUP],AREA
            FROM security.xls (biff, embedded labels, table is Users$);

            LEFT JOIN (AccessPermit)
            LOAD
            USERID,
            SALESMAN

            FROM security.xls (biff, embedded labels, table is UserInfo$);
            Section Application;
            STAR IS *;

            LOAD
            SalesManAppField,
            SalesManAppField as SALESMAN
            FROM .....





              • Section Access/Application: ISSUES

                Oleg,

                NAILED AGAIN!

                Worked perfectly, thank you so much!!!

                • Section Access/Application: ISSUES

                  Oleg,

                  After I implemented this solution in the app, I have been ordered to enhance it...

                  Now, when a user that is a MANAGER of a subset of salesmen logins in, it must see only data related to its "team"...

                  I tried creating a MANAGER field in the .XLS file that holds the security information, but with no success at first...

                   

                  Have you or anyone following this post ever stepped upon something like it?

                  Thx again!!!

                    • Section Access/Application: ISSUES
                      Oleg Troyansky

                      Thiago,

                       

                      You can add another field, MANAGER, and create another corresponding field in your application - for example, SalesManager. Build an association between SalesManagers and Sales People (reading from Excel, for example). For those users that are Managers, fill out their MANAGER field. Then, associate MANAGER field from Section Access with the SalesManager field from your application, and it should work in the same way.

                      cheers,

                        • Section Access/Application: ISSUES

                          Oleg, thanx for answering!

                          Let me check if I got this right...

                          "You can add another field, MANAGER, and create another corresponding field in your application"

                          My excel file have two sheets (tables) to control de access so far...
                          USER (Access, UserID, Password) and USERINFO (UserID, Salesmen). The Salesmen is my common field with the app (just like MANAGER must become), and made it work perfectly according to the first proposal.

                          "Build an association between SalesManagers and Sales People". For those users that are Managers, fill out their MANAGER field. Then, associate MANAGER field from Section Access with the SalesManager field from your application, and it should work in the same way."

                          That's the 1 million dollar question... I don't see in which table (USER or USERINFO) the MANAGER field must be created, how must I fill it (with the managers names, or with BOOL values), and how may I create it in the app (add it to the excel file, or bring it INLINE within the app)... the Salesmen field used previously was already in the app, making everything easier at first.

                           

                          I'm trying things out like you have told, but I would very much appreciate another look of yours into this matter.

                          Thank you so much once again!