Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Section access from database (ODBC connection)

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

3 Replies
martin59
Valued Contributor II

Re: Section access from database (ODBC connection)

Hi,

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

Martin Favier

Not applicable

Re: Section access from database (ODBC connection)

Hi, thank you for your answer but It seems that I'm not authorized to open the document in the link

Employee
Employee

Re: Section access from database (ODBC connection)

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

Section Access:

Load

     Upper(Group) as NTNAME,

     If(Group='Admin','ADMIN','USER') as ACCESS;

SQL SELECT Group FROM <DataBaseTable> ;

Section Application;

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.

HIC

Community Browser