topic Re: section access profiles user admin in QlikView

section access profiles user admin

Judicael — Sat, 16 Nov 2024 20:08:26 GMT

Hello,

I create a session access fir reduction. Works Well but I want also get the profiles user

How can I do that, please ?

SECTION ACCESS;

SECTION_ACCESS_USERS:
LOAD
ACCESS,
UPPER(NTNAME) AS NTNAME,
PROCESS_REDUCTION,
UPPER(PROFILES_USERS_QUALIFICATION) AS LINK_PROFILES
FROM $(vFolderQvd)Securite_User_Admin.qvd(qvd);

SECTION APPLICATION;

LINK_PROFILE_USERS:
LOAD
UPPER(PROFILES_USERS_QUALIFICATION) AS LINK_PROFILES,
PROFILES_USERS_QUALIFICATION
FROM $(vFolderQvd)Securite_User_Admin.qvd(qvd);

LOAD
PROFILES_USERS_QUALIFICATION,
PROFILES_USERS,
USERNAME,
VALIDATEUR,
VALIDATEUR_RESTREINT,
QUALIFICATEUR,
GESTIONNAIRE
FROM $(vFolderQvd)PROFILES_USERS_FINALE.qvd(qvd);

Thanks for your help.

Re: section access profiles user admin

Judicael — Wed, 04 Sep 2019 23:44:15 GMT

When I test the login USER only the system account (admin) is granted with the configuration table not users.

Re: section access profiles user admin

Vegar — Thu, 05 Sep 2019 06:22:00 GMT

Try to run the script below in a separate application. It's your original script without the section access activated. Add a couple of list boxes, one per table. Click on the different NTNAMES fields to figure out what's happening.

//SECTION ACCESS;

SECTION_ACCESS_USERS:
LOAD
ACCESS,
UPPER(NTNAME) AS NTNAME,
PROCESS_REDUCTION,
UPPER(PROFILES_USERS_QUALIFICATION) AS LINK_PROFILES
FROM $(vFolderQvd)Securite_User_Admin.qvd(qvd);

//SECTION APPLICATION;

LINK_PROFILE_USERS:
LOAD
UPPER(PROFILES_USERS_QUALIFICATION) AS LINK_PROFILES,
PROFILES_USERS_QUALIFICATION
FROM $(vFolderQvd)Securite_User_Admin.qvd(qvd);

LOAD
PROFILES_USERS_QUALIFICATION,
PROFILES_USERS,
USERNAME,
VALIDATEUR,
VALIDATEUR_RESTREINT,
QUALIFICATEUR,
GESTIONNAIRE
FROM $(vFolderQvd)PROFILES_USERS_FINALE.qvd(qvd);