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

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

Tue, 17 May 2011 05:09:00 GMT

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 — Tue, 17 May 2011 05:38:59 GMT

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