Security not working

[Anonymous]

Hi,

attached shows two tabs.  the first is the security and the second it the load.  The Security for Luis.Black is not working.

Any help appreciated please.

Regards,

Laura 

[tamilarasu]

The field values should be in caps. Could you post your NewState data here.?

[Anonymous]

These are the actual results.  I.e. I changed the Case in the script not to disclose table/fields etc....   

NSW-Direct

NSW-Membership

SA

TAS

VIC

[tamilarasu]

Please try again like below attachment (Replace only NTDOMAINSID).

[stabben23]

SectionAccess;
LOAD * INLINE[
ACCESS,   NTNAME,               NTDOMAINSID, NEWSTATE
USER,     NSYDNEY\luis.black,      XXXX,      VIC
ADMIN,    NSYDNEY\gen.rae,         XXXX,      

];

Try to use 'blank' in NEWSTATE instead of '*'.

[Anonymous]

no luck.  Am I able to get someone to do a WebEx or Goto meeting with me at all?

[tamilarasu]

No clue. I have a similar script which is working fine for me (Even the field label is in small letters).

[Anonymous]

thanks all for you help.  I've tried everything and still no luck. so will try fresh tomorrow

[#9]

     Could you please try upper(NTNAME) in your script. As below

SectionAccess;
LOAD * INLINE[
ACCESS,   NTNAME,               NTDOMAINSID, NEWSTATE
USER,     NSYDNEY\LUIS.BLACK,      XXXX,      VIC
ADMIN,    NSYDNEY\GEN.RAE,         XXXX,     

];

SECTION Application;

[Anonymous]

Question please....Does the Access field need to be a %key field or can it be any field loaded?

[tresesco]

It can be any field. I suggest to refer : Section Access for deep understanding.