Section access not working (Access denied)

[Anonymous]

Hi,

I have a question,

I have a section access table like this:

ACCESS	DISPLAYNAME	OPERATION	REGION	AREA	NTNAME
USER	Andy	*	*	AJK	aa\andy
USER	Dony	*	BDS	*	aa\dony

And I have data table like this:

OPERATION	REGION	AREA	SALES
AS	AHK	AJK	1000
BS	RLL	LPP	100

I load the section access table like this:

SECTION Access;

Access:

LOAD

     upper(ACCESS) as ACCESS,

     NTNAME as NTNAME,

     upper(DISPLAYNAME) as DISPLAYNAME,

     OPERATION,

     REGION,

     AREA

FROM

............

SECTION Application;

Sales:

LOAD

OPERATION,

REGION,

AREA,

SALES

FROM

....................

But when i login as Andy (NTNAME), the pop up error appeared (ACCESS DENIED).

Anybody has the idea ?

The result i expect is ANDY can only see this data (AREA AJK):

PERATION	REGION	AREA	SALES
AS	AHK	AJK	1000

Thanks in advance.

[vardhancse]

Hi,

* may not work always. once can please try to give all the operation and region complete names

[Anonymous]

Hi, thanks for the answer,

I've try to concate with my complete data like this.

SECTION Access;

Access:

LOAD

     upper(ACCESS) as ACCESS,

     NTNAME as NTNAME,

     upper(DISPLAYNAME) as DISPLAYNAME,

     OPERATION,

     REGION,

     AREA

FROM

............

conctenate (Access)

LOAD distinct  ------> this one is from data table.

OPERATION,

REGION,

AREA

I'm using * in order to access all operation or region defined.

Thanks.

Really need your help.

[Anil_Babu_Samineni]

Access denied means, might be services problem. Have you checked is there all services are running or not.

[tresesco]

Try upper() for NTNAME as well like:

Upper(NTNAME) as NTNAME,

[vardhancse]

as tresesco‌ said make sure all the fields and data was in upper.

And instead of distinct just enter one record and see.

This is some thing authorization, how you are managing authentication to access point

[#7]

Hi,

All the data within the section access must be in uppercase... So make sure everyting is in uppercase.

Thanks

[#8]

When I first started using Section Access I did not realized you had to save the QlikView document. Then completely close the QVW and reopen it before the changes took affect.

I assuming you are following these steps, but just wanted to make sure.

- Stan