topic Re: Security not working in QlikView

Security not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Security not working

trdandamudi — Thu, 08 Sep 2016 03:04:10 GMT

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

Re: Security not working

Anonymous — Thu, 08 Sep 2016 03:56:55 GMT

that was a typo...

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

Re: Security not working

trdandamudi — Thu, 08 Sep 2016 04:12:43 GMT

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

Re: Security not working

Anonymous — Thu, 08 Sep 2016 04:23:29 GMT

still not working.

anything else I can check?

Re: Security not working

arulsettu — Thu, 08 Sep 2016 04:28:22 GMT

try this

SectionAccess:

LOAD Upper(NTNAME) as NTNAME INLINE [

ACCESS, NTNAME, NTDOMAINSID, NewState

USER, NSYDNEY\luis.black, XXXX, VIC

ADMIN, NSYDNEY\gen.rae, XXXX, *

];

Re: Security not working

trdandamudi — Thu, 08 Sep 2016 04:33:27 GMT

Are you able to login as Admin ?

Re: Security not working

tresB — Thu, 08 Sep 2016 04:35:05 GMT

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;

Re: Security not working

Anonymous — Thu, 08 Sep 2016 04:52:52 GMT

Hi Tresesco,

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

Syntax error, missing/misplaced FROM:

LOAD * INLINE[

Re: Security not working

Anonymous — Thu, 08 Sep 2016 04:57:31 GMT

found syntax error

Re: Security not working

tresB — Thu, 08 Sep 2016 05:05:58 GMT

Put a space between 'INLINE' and '[' and retry.

Re: Security not working

Anonymous — Thu, 08 Sep 2016 05:15:54 GMT

syntax issue. fixed but security still not working.

Re: Security not working

pradeep_s — Thu, 08 Sep 2016 05:22:03 GMT

Please UnQualify NewState Column.

QUALIFY*;

UnQualify NewState;

WAU:

Load

AccountNumber

,AccountName

,NewState;

SQL

SELECT

a.AccountNumber

,a.AccountName

,CASE WHEN a.State='NSW' THEN 'NSW-Black'

WHEN a.State='VIC_South' THEN 'VIC-Red'

ELSE a.State End as NewState

FROM Case a;

UNQUALIFY *;

Re: Security not working

pradeep_s — Thu, 08 Sep 2016 05:25:01 GMT

Laura,

Please UnQualify NewState Column.

QUALIFY*;

UnQualify NewState;

WAU:

Load

AccountNumber

,AccountName

,NewState;

SQL

SELECT

a.AccountNumber

,a.AccountName

,CASE WHEN a.State='NSW' THEN 'NSW-Black'

WHEN a.State='VIC_South' THEN 'VIC-Red'

ELSE a.State End as NewState

FROM Case a;

UNQUALIFY *;

Re: Security not working

tresB — Thu, 08 Sep 2016 05:34:49 GMT

How is the behavior? Is it working for some and not for some, or working for none?

Re: Security not working

Anonymous — Thu, 08 Sep 2016 05:37:21 GMT

all the others have access to everything and they do see everything. its just luis.black that should see only VIC and see's everything

Re: Security not working

tresB — Thu, 08 Sep 2016 05:41:52 GMT

Have you checked the 'Initial data reduction ..' in the document properties settings?

Re: Security not working

Anonymous — Thu, 08 Sep 2016 05:46:06 GMT

yes. I've checked and they are on. I added another user with the same credentials and their security didn't work either

Re: Security not working

tamilarasu — Thu, 08 Sep 2016 05:48:42 GMT

Hi Laura,

Try below attached file.

Re: Security not working

Anonymous — Thu, 08 Sep 2016 05:54:51 GMT

no luck. does it have something to do with the field being created from a Case?