2 Replies Latest reply: Jul 4, 2012 10:38 PM by olfesio180 RSS

    doesn't work section access after reload using NTNAME

      hi,

       

      i have ploblem of section access.

      i wrote following expressions for using section access...

       

      SECTION Access;

      ACCESS:

      LOAD

      "ACCESS_KBN"           AS [ACCESS],

      "USER_ID"                     AS [USERID],

      "PASSWORD"                     AS [PASSWORD],

      ' '                                        AS [NTNAME],

      "GRP_USER_ID"           AS [GRP_USERID],

      "SSK_USER_ID"           AS [SSK_USERID],

      "KMK_USER_ID"           AS [KMK_USERID]

      ;

      select QA.ACCESS_KBN AS ACCESS_KBN,

                QA.USER_ID AS USER_ID,

                QA.PASSWORD AS PASSWORD,

                QA.USER_ID AS GRP_USER_ID,

                QA.USER_ID AS SSK_USER_ID,

                QA.USER_ID AS KMK_USER_ID

      from QV_ACCESSCTL QA

      ;

       

      //using NTNAME to open this file

      concatenate(ACCESS)

      LOAD * INLINE [

      ACCESS,USERID,PASSWORD,NTNAME,GRP_USERID,SSK_USERID,KMK_USERID

      ADMIN,*,*,QVSR\ADMINISTRATOR,*,*,*

      ];

       

       

      i deployed this file to server after reload this scripts by NTNAME of ADMINISTRATOR.

      i aceess and open this file by using Internet Explore then it doesn't work section access without NTNAME.

      i tryed to enter ID and PASSWORD 3 times but the file is not opened....

       

      please anyone tell me this solution.

       

       

      regards,

      olfesio

        • Re: doesn't work section access after reload using NTNAME
          Fernando Suzuki

          Hi olfesio,

           

          try this:

          SECTION Access;

          ACCESS:

          LOAD

          "ACCESS_KBN"           AS [ACCESS],

          "USER_ID"                     AS [USERID],

          "PASSWORD"                     AS [PASSWORD],

          '*'                                        AS [NTNAME],

          "GRP_USER_ID"           AS [GRP_USERID],

          "SSK_USER_ID"           AS [SSK_USERID],

          "KMK_USER_ID"           AS [KMK_USERID]

          ;

          select QA.ACCESS_KBN AS ACCESS_KBN,

                    QA.USER_ID AS USER_ID,

                    QA.PASSWORD AS PASSWORD,

                    QA.USER_ID AS GRP_USER_ID,

                    QA.USER_ID AS SSK_USER_ID,

                    QA.USER_ID AS KMK_USER_ID

          from QV_ACCESSCTL QA

          ;

           

          //using NTNAME to open this file

          concatenate(ACCESS)

          LOAD * INLINE [

          ACCESS,USERID,PASSWORD,NTNAME,GRP_USERID,SSK_USERID,KMK_USERID

          ADMIN,*,*,QVSR\ADMINISTRATOR,*,*,*

          ];