Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Some user cannot access to my application

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!

1 Solution

Accepted Solutions
MVP
MVP

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_USATLANTIC
INTERNATIONAL_USATLANTIC
DOMESTIC_USDOMESTIC
INTERNATIONAL_USDOMESTIC
DOMESTIC_FORINTERNATIONAL
DOMESTIC_USINTERNATIONAL
INTERNATIONAL_FORINTERNATIONAL
INTERNATIONAL_USINTERNATIONAL
DOMESTIC_USLATIN_AMERICA
INTERNATIONAL_USLATIN_AMERICA
DOMESTIC_USPACIFIC
INTERNATIONAL_USPACIFIC
DOMESTIC_USSYSTEM
INTERNATIONAL_USSYSTEM

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.

View solution in original post

2 Replies
MVP
MVP

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_USATLANTIC
INTERNATIONAL_USATLANTIC
DOMESTIC_USDOMESTIC
INTERNATIONAL_USDOMESTIC
DOMESTIC_FORINTERNATIONAL
DOMESTIC_USINTERNATIONAL
INTERNATIONAL_FORINTERNATIONAL
INTERNATIONAL_USINTERNATIONAL
DOMESTIC_USLATIN_AMERICA
INTERNATIONAL_USLATIN_AMERICA
DOMESTIC_USPACIFIC
INTERNATIONAL_USPACIFIC
DOMESTIC_USSYSTEM
INTERNATIONAL_USSYSTEM

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.

View solution in original post

Not applicable

Thanks Swuehi!