Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question about Section Access

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, AFRICA

USER, USER2, U2, AMERICA

USER, USER3, U3, ASIA

USER, USER4, U4, EUROPE

USER, USER5, U4, AMERICA

USER, USER5, U5, *

];

Section Application;

SALES:

LOAD * INLINE [                 I WANT KNOW EXPLINATION OF THIS  OR WHAT IS CAUSE TO WRITE SECTION APPLICATION TABLE                                                                       HERE AND ITS MANDATORY?

REGION, PROFIT

AFRICA, 1000

AMERICA, 2000

ASIA, 3000

EUROPE, 4000

OCEANIA, 5000

];

4 Replies
Miguel_Angel_Baeyens

Hi,

Section Access; // means that following comes the security table with users, roles, reduction fields and omitted columns

...

Section Application; // means that the security table has been already loaded, and following comes the normal script and the data model.

Both of them are mandatory if you are using section access.

Miguel

maxgro
MVP
MVP

yes, is mandatory because there is a section access before that

from online help

section (access | application)

"

With the section statement, it is possible to define whether the subsequent Load and Select (SQL) statements should be considered as data or as a definition of the access rights.

The syntax is:

section (access | application)

Examples:

Section access;

AuthorizationTable:

SQL SELECT ACCESS, NTNAME, REGION FROM AuthorizationTable ;

Section application;

If nothing is specified, section application is assumed. The section definition is valid until a new section statement is made.

"

SunilChauhan
Champion
Champion

Hi

Section access and section application  are Indicator of begining and end of code for security

without them security or access can not be fullfilled.

try without any of them an see the result.

hope this helps

Sunil Chauhan
swuehl
MVP
MVP

Please also have a look at

Introduction to Section Access