how to load NT users from SQL Server DB to grant access?

[#1]

Hello, is it possible to load 'user' and 'access' data directly from a SQL Server database to compair with the actual NT User logged and grand access to my QlikView file?

Thank you in advance.

[Anonymous]

Sure, it sounds like you want to populate your section access with data from a SQL Server database?

That's fine, section access lets you load data from any source, just like normal QlikView table structures.

[#3]

great, can you help me with an example please?

I have some code but I would prefer to work with a clear and simple example if it is possible.

Section_Access:
LOAD Distinct
Upper(ACCESS ) as ACCESS
,upper(NTNAME ) as NTNAME


Concatenate (Section_Access)
LOAD * INLINE [   
      ACCESS, NTNAME
      ADMIN, AMERICAS\$qlikviewitg001
      ADMIN, AMERICAS\$qlikviewpro001   
];

SECTION Application ;

thank you for your attention.