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 

[trdandamudi]

In your Section Access, you have listed four fields but you  have five values ?

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

[Anonymous]

that was a typo...

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

[trdandamudi]

In your response you are still showing a extra blank field for the "User". So try the below and see.

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

[Anonymous]

still not working.

anything else I can check?

[arulsettu]

try this

SectionAccess:

LOAD Upper(NTNAME) as NTNAME  INLINE [

ACCESS,   NTNAME,               NTDOMAINSID, NewState

USER,     NSYDNEY\luis.black,      XXXX,      VIC

ADMIN,    NSYDNEY\gen.rae,         XXXX,       *

];

[trdandamudi]

Are you able to login as Admin ?

[tresesco]

Be careful about using the field values and filed names in upper case. Try like:

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

};

...

WAU:

Load

      AccountNumber

      ,AccountName

      ,Upper(NewState) as NEWSTATE;

[Anonymous]

Hi Tresesco,

I receive the following syntax error but cant see the mistake?:-

Syntax error, missing/misplaced FROM:

LOAD * INLINE[

[Anonymous]

found syntax error