Section access from database (ODBC connection)

[#1]

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

[martin59]

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

[#3]

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

[hic]

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