Section Access issue - qlikview

[gidon500]

Hi

I have a long table with FAMP filed , that represent manufacturer

ACCESS	USERID	PASSWORD	FAM
ADMIN	G	D	*
USER	D	D	INTEL
USER	A	A	DELL
USER	B	B	EPSON

using this table I get access denied  . but when I change to :

ACCESS	USERID	PASSWORD	FAM
ADMIN	G	D	*
ADMIN	D	D	INTEL
ADMIN	A	A	DELL
ADMIN	B	B	EPSON

all is OK user D get intel only , A  gets dell only and B gets  EPSON only

G see them all . 

but now they are all admin , which is very bad for me

what am I doing wrong , is there a flag I need to change

thanks for your help

gidon

[Peter_Cammaert]

IMHO this behavior cannot be explained form the information you provided. We could start guessing for the other details, but it would be more helpful if you could upload a small exampel document that exhibits this behavior. Can you do that?

Best,

Peter

[gidon500]

ok will try it is big file

[Peter_Cammaert]

You don't have to add any data except for a single Section Application table to which the FAM field can link to.

[gidon500 · Accepted solution]

Hi Guys

I have found the problem ,

it seems that in earlier stage of the ERD build

I have used a FIELD name USERID ,

this caused the problem  ,

when loading the data qlik did not advise an error

I have removed the table of users

it is OK

I think the when loading should be an error  on load of data

gidon