4 Replies Latest reply: Mar 20, 2013 6:09 AM by Martin Vierling RSS

    Section Access on multiple fields and 'Jokers'?

    Martin Vierling

      Hi there,

       

      I am sorry that I have to ask you guys again but I am desperate...

       

      Assuming I have a table like this:

       

      Load * Inline [

      AREA, COUNTRY, CUSTNO, Amount

      1000, DE, 123456, 100

      1100, DE, 321654, 101

      1000, US, 654987, 102

      1200, US, 987654, 103

      (and a lot more)

      ];

       

      and I have the following rules:

       

      - User 1 should have access to all data and have ADMIN rights

      - User 2 should have access to all records with COUNTRY = DE, independent of all other columns, and have USER rights

      - User 3 should have access to all records with AREA= 1000 but NOT CUSTNO = 123456, independent of all other columns, and have USER rights

      - User 4 should have access to all records with COUNTRY = DE and AREA = 1000, independent of all other columns, and have USER rights

       

      I made it running with giving all users ADMIN rights but that of course won't work in Accesspoint (just locks out all USERs). I didn't find sufficient information about implementing section access with multiple fields and 'Jokers' and it is driving me crazy... so help would be really great! :-)

       

      Thanks a lot in advance.

       

      Kind regards,

      Martin