Section Access Table Profoles

[Judicael]

Hello,

I create a section access tab:

LOAD * INLINE [

ACCESS, NTNAME, PROFILES, REDUCTION

ADMIN, ADMIN, *,*

USER, USER1,VAL

USER, USER1,GEST

USER, USER2,VAL

USER, USER1,QUAL

USER, USER1,GEST

];

APPLICATION_PROFILES:

LOAD * INLINE [

PROFILES, VALIDATOR, GESTIONNARY, QUALIFICATOR

VAL, 1,0,0

GEST, 0,1,0

QUAL,0,0,1

];

When User connect, he has profiles and flag validator, gestionnary, qualificator

Example User1 has profiles =VAL and GEST thus VALIDATOR=1 and GESTIONNARY=1

How can I do that ?

Thanks for yuour help.

[Miguel_Angel_Baeyens]

Your code looks good to me: you need as many lines in the section access table as reduction values you want to give to any user. In this case USER1 appears 3 times, so he will have all 3 VAL, GEST and QUAL profiles (GEST is duplicated, though).

Note that to read the appropriate value in the application and given how you defined the profiles, you will need to use Max() or similar in the application, since USER1 will have "0" and "1" for the field VAL, for example.

[Judicael]

My section access is this : DAta REduction Works Good but I want to get the profile user with PROFILES_USERS but nothing happens. How can I fix it ?

SECTION ACCESS;

SECTION_ACCESS_USERS_ADMIN:
LOAD
ACCESS,
NTNAME,
PROCESS_REDUCTION,
PROFILES_USERS
RESIDENT TMP_SECTION_ACCESS;

SECTION APPLICATION;

APPLICATION_PROFILES:
LOAD
PROFILES_USERS,
RANGEMAX(IF(WILDMATCH(PROFILES_USERS,'Validator','Validateur Restreint',1,0) , 1)) AS VALIDATOR,
RANGEMAX(IF(WILDMATCH(PROFILES_USERS,'Qualificator',1,0) , 1)) AS QUALIFICATOR,
RANGEMAX(IF(WILDMATCH(PROFILES_USERS,'Gestionnary',1,0) , 1)) AS GESTIONNARY
RESIDENT TMP_SECTION_ACCESS;

DROP TABLE TMP_SECTION_ACCESS;

[Judicael]

Question : NTNAME works only with DOMAIN ans LOCAL MACHINE only?

[Miguel_Angel_Baeyens · Accepted solution]

NTNAME will contain the result of OSUser(), that is, the authenticated user reaching QlikView in the form DIRECTORY\ACCOUNT, regardless the authentication mechanism.