How to read users from SQL Server or QVD into Section Access

[#1]

Hi All,

I want to use Section Access to control the access control, my users are stored in SQL Server, how can I read them and load it into Section Access?

I know how to read them from EXCEL.

My Section Access table looks like this:

ACCESS, USERID, REDUCTION

Could you provide me some script?

Thanks.

[amars]

Hi,

YouThe only thing u need to do is just create Aliases for the fields like this

Section Access:

SQL Select 'USER' as ACCESS, Upper(uIDField) as USERID, Upper(REDUCTION) as REDUCTION from Table;

Section Application:

SQL Select Upper(REDUCTION) as REDUCTION from Table;

Thanks See if this works