2 Replies Latest reply: Jul 13, 2016 4:20 PM by Krishnapriya Arumugam RSS

    Section Access for all the values (*)

    Reshma Kala

      Hi all,

       

      I am trying to implement section access on a field with NTNAME. Here is my script

       

       

      LOAD * INLINE [

      ACCESS, NTNAME, FIELD

      ADMIN, USER1,

      ADMIN, USER2,

      USER, USER3, A

      USER, USER4, B ];

       

      This works perfectly fine on desktop. When I publish this on Server, it says "Failed to open document. Access denied". When tried putting in a value for FIELD beside Admin, I can see the data related to that value or else the access is denied. I cannot manually include all the values for FIELD as I have few hundreds. How can I specify ALL values for Admins. Using * is giving me only A and B access.

       

       

      Thank you.

        • Re: Section Access for all the values (*)
          Krishnapriya Arumugam

          Hi,

           

          You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

          Hope below example will give you details.

           

          Section_Access_Table:

          Load

          'ADMIN' as ACCESS,

          'ADMIN' as NTNAME,

          *;

          SQL select distinct FIELD from Table_Name;

          concatenate

          LOAD * INLINE [

          ACCESS, NTNAME, FIELD

          ADMIN, USER1,

          ADMIN, USER2,

          USER, USER3, A

          USER, USER4, B ];

           

          Section Access;

          Load * from Section_Access_Table;

          Section Application;

          • Re: Section Access for all the values (*)
            Krishnapriya Arumugam

            Hi,

             

            You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

            Hope below example will give you details.

             

            Section_Access_Table:

            Load

            'ADMIN' as ACCESS,

            'ADMIN' as NTNAME,

            *;

            SQL select distinct FIELD from Table_Name;

            concatenate

            LOAD * INLINE [

            ACCESS, NTNAME, FIELD

            ADMIN, USER1, *

            ADMIN, USER2, *

            USER, USER3, A

            USER, USER4, B ];

             

            Section Access;

            Load * from Section_Access_Table;

            Section Application;