topic Re: Section Access Table Profoles in QlikView

Section Access Table Profoles

Judicael — Sat, 16 Nov 2024 20:09:19 GMT

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.

Re: Section Access Table Profoles

Miguel_Angel_Baeyens — Tue, 03 Sep 2019 12:18:02 GMT

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.

Re: Section Access Table Profoles

Judicael — Tue, 03 Sep 2019 14:51:49 GMT

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;

Re: Section Access Table Profoles

Judicael — Tue, 03 Sep 2019 21:28:33 GMT

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

Re: Section Access Table Profoles

Miguel_Angel_Baeyens — Wed, 04 Sep 2019 15:33:53 GMT

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