Discussion Board for collaboration on QlikView Scripting.
Hello every body,
I have a question about how to retreive the user's groups from a database to use them into the section access of my application.
The first step, the authentication, is already ok but now, I would like to know how to put the authenticated users into the section access.
Thank you in advance
I'm not sure to understand as well but you'll certainly find how to do what you want in this document.
Hope that helps you
Hi, thank you for your answer but It seems that I'm not authorized to open the document in the link
If you want to load a number of AD groups from a database, and give full rights to the Admin group and USER rights to the rest, then you can do a
Upper(Group) as NTNAME,
If(Group='Admin','ADMIN','USER') as ACCESS;
SQL SELECT Group FROM <DataBaseTable> ;
The problem comes when you want to link a group to specific region or product group. For this, you will need to have an authorization table in the DB that defines these relationships.