topic Re: Some user cannot access to my application in QlikView

Some user cannot access to my application

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

May I share some of your idea why my USER3 and USER5 cannot access to my qlikview application?

Following is my security control script:

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD,%REGION,%FLIGHTTYPE

ADMIN, ADMIN, ADMIN123, *, *

ADMIN, ADMIN, ADMIN123, SYSTEM, *

USER, USER1, USER123, ATLANTIC, DOMESTIC_FOR

USER, USER1, USER123, INTERNATIONAL, INTERNATIONAL_US

USER, USER2, USER123, INTERNATIONAL, INTERNATIONAL_FOR

USER, USER3, USER123, PACIFIC, INTERNATIONAL_FOR

USER, USER5, USER123, LATIN_AMERICA, DOMESTIC_FOR

USER, USER4, USER123, DOMESTIC, DOMESTIC_US

];

Section Application;

Inline_1:

LOAD * INLINE [

Flight Type, %FLIGHTTYPE

"Domestic, Foreign Carriers", DOMESTIC_FOR

"Domestic, US Carriers Only", DOMESTIC_US

"International, Foreign Carriers", INTERNATIONAL_FOR

"International, US Carriers Only", INTERNATIONAL_US

];

Inline_2:

LOAD * INLINE [

Carrier's Operating Region, %REGION

Atlantic, ATLANTIC

Domestic, DOMESTIC

International, INTERNATIONAL

Latin America, LATIN_AMERICA

Pacific, PACIFIC

System, SYSTEM

];

Attached is my application.

Password to hidden script : 0000

Only user3. and user5 cannot access to the application, but all others are good. User3 and user5 turn up with an "Access denied to this QlikView document" error.

Thanks in advance!

Re: Some user cannot access to my application

swuehl — Mon, 13 Jun 2016 21:22:42 GMT

You need to compare your section access table with the combinations of %REGION and %FLIGHTTYPE in your application:

LOAD * INLINE [

ACCESS, USERID, PASSWORD,%REGION,%FLIGHTTYPE

ADMIN, ADMIN, ADMIN123, *, *

ADMIN, ADMIN, ADMIN123, SYSTEM, *

USER, USER1, USER123, ATLANTIC, DOMESTIC_FOR

USER, USER1, USER123, INTERNATIONAL, INTERNATIONAL_US

USER, USER2, USER123, INTERNATIONAL, INTERNATIONAL_FOR

USER, USER3, USER123, PACIFIC, INTERNATIONAL_FOR

USER, USER5, USER123, LATIN_AMERICA, DOMESTIC_FOR

USER, USER4, USER123, DOMESTIC, DOMESTIC_US

];

%FLIGHTTYPE	%REGION
DOMESTIC_US	ATLANTIC
INTERNATIONAL_US	ATLANTIC
DOMESTIC_US	DOMESTIC
INTERNATIONAL_US	DOMESTIC
DOMESTIC_FOR	INTERNATIONAL
DOMESTIC_US	INTERNATIONAL
INTERNATIONAL_FOR	INTERNATIONAL
INTERNATIONAL_US	INTERNATIONAL
DOMESTIC_US	LATIN_AMERICA
INTERNATIONAL_US	LATIN_AMERICA
DOMESTIC_US	PACIFIC
INTERNATIONAL_US	PACIFIC
DOMESTIC_US	SYSTEM
INTERNATIONAL_US	SYSTEM

You see that the combination defined in the SA table for User3 and User5 do not exist in your model.

Since you are using option strict exclusion in Opening tab of doc properties, for these users access is denied.

Hope this clarifies your issue.

How to correct? Either add data to your model that allows these combinations or change the SA table.

Re: Some user cannot access to my application

Tue, 14 Jun 2016 19:43:39 GMT

Thanks Swuehi!