Help with Section Access

[hopkinsc]

Hi All,

I am trying to get section access working with NTNAMES. it works when entering UserID and PW but i cant seem to get it to work using NTNAMES.

can anyone see if i am doing anything wrong please?

I have attached the files needed.

The User ID's/passwords are

admin, admin

user1, user

Many thanks

[hopkinsc]

hi Jeroen, yes i did. the one i uploaded has got my ntname in it..i just redownloaded it to check..

[jjordaan]

Can you check the attachment again.

You have to change the NTNAme again to your own

[hopkinsc]

Hi Jeroen,

not sure what happened there but the copy i had did have my ntname in the script..

anyway, i have changed it again and uploaded a new copy and it still doesnt work. it lets me in now using my nt name, but it doesnt do any data reduction..

I should only be able to see RowSecLink 00400

[hopkinsc]

actually, it doesnt seem to be working at all. i have just changed mt NTNAME to something silly and it still let me in...

[hopkinsc · Accepted solution]

Ok i know have it working

I had to change the section access part to..

PermissionTable:

NoConcatenate

LOAD

ACCESS,

USERID,

PASSWORD,

UPPER(NTNAME) as NTNAME,

UPPER(ROWSECLINK) as ROWSECLINK

Resident TempTable;

That now lets me in with data reduction..

Thanks for your help

[jjordaan]

Can you check this one.

[hopkinsc]

Hi, no this didnt work again but if you rename the fields within the sectiojn access it works. see my attached file.

Thanks for your help