topic Section access not working (Access denied) in QlikView

Section access not working (Access denied)

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

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.

Re: Section access not working (Access denied)

vardhancse — Thu, 01 Sep 2016 03:00:53 GMT

Hi,

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

Re: Section access not working (Access denied)

Anonymous — Thu, 01 Sep 2016 03:21:37 GMT

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.

Re: Section access not working (Access denied)

Anil_Babu_Samineni — Thu, 01 Sep 2016 03:35:55 GMT

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

Re: Section access not working (Access denied)

tresB — Thu, 01 Sep 2016 05:16:31 GMT

Try upper() for NTNAME as well like:

Upper(NTNAME) as NTNAME,

Re: Section access not working (Access denied)

vardhancse — Thu, 01 Sep 2016 05:56:29 GMT

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

Re: Section access not working (Access denied)

Thu, 01 Sep 2016 06:23:26 GMT

Hi,

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

Thanks

Re: Section access not working (Access denied)

Fri, 02 Sep 2016 01:39:00 GMT

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