topic Re: Security does not work in QlikView

Security does not work

Anonymous — Wed, 25 Feb 2015 17:28:20 GMT

Hi all

In my script

Section Access;
LOAD If(match(Upper(USER_ID), 'PARAJ'),'ADMIN', 'USER') As ACCESS,
Upper(USER_ID) As USERID,
'MYPW' AS PASSWORD,
ENTITY_ID & '-' & Text(LOB_ID) & '-' & Text(UBR_ID) & '-' & Text(SUB_UBR_ID) As SecurityKey;

SELECT DISTINCT U.USER_ID, P.LEGAL_ENTITY_ID, P. LOB_ID, P. UBR_ID, P.SUB_UBR_ID
FROM USER_ACCESS U,
REF_SUB_UBR P
WHERE U.ENTITY_ID = P.LEGAL_ENTITY_ID;
Section Application

;

And same SecurityKey I have in fact table

Records displayed perfect filtering in my case on my PC, but on others it display either mine data or all

I also have applied data reduction 1.

2. Dynamic update

Why data do not pop up based on access, any idea please?

I need to restrict data as per user's access given

I appreciate your help

Thanks

Re: Security does not work

Anonymous — Wed, 25 Feb 2015 18:26:48 GMT

I cannot say that this info is enough, but for successful data reduction the SecurityKey should be renamed to SECURITYKEY, and the upper() function should be used:

upper(ENTITY_ID & '-' & Text(LOB_ID) & '-' & Text(UBR_ID) & '-' & Text(SUB_UBR_ID)) As SECURITYKEY

That is, the reduction field name and field data must be in all capital - both in section access and section application.

Re: Security does not work

Anonymous — Wed, 25 Feb 2015 18:43:34 GMT

correct