doesn't work section access after reload using NTNAME

[#1]

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

[fosuzuki · Accepted solution]

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,*,*,*

];

[#3]

hi Fernando,

thnak you for your help!

it's solved  to try your expresson!

regards,