Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
Thanks Swuehi!