topic Re: Section access from database (ODBC connection) in QlikView

Section access from database (ODBC connection)

Fri, 15 Feb 2013 10:16:27 GMT

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

Re: Section access from database (ODBC connection)

martin59 — Fri, 15 Feb 2013 12:46:31 GMT

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

Re: Section access from database (ODBC connection)

Fri, 15 Feb 2013 13:16:56 GMT

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

Re: Section access from database (ODBC connection)

hic — Fri, 15 Feb 2013 14:37:50 GMT

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