Section Access

[#1]

Hallo,

we are using QV11-Server and Publisher.

I use following Section Access:

Section

Access;



LOAD Upper (ACCESS) As ACCESS,

  Upper (NTNAME) As NTNAME,

  Upper (GRUPPE) As GRUPPE,

  Upper (MODUL) As MODUL,

  Upper (VERBAND) As VERBAND

From http://deqv3:4780/QMS/AuthTable(html, utf8, embedded labels, Table is Aussendienst);

ACCESS     NTNAME                         GRUPPE     MODUL     VERBAND

ADMIN     de_garant\h.steinmann          *                    *               *

ADMIN     de_garant\gmsservice          *                    *                 *                              <- service user on QV-SERVER

USER       de_garant\user01                    *               *                   GMG

USER       de_garant\user02                    *               3                    GMG

USER       de_garant\user03                    *               4                    GMG

USER       de_garant\user04                    *               1                    *

This doesn't work on the server.

Can anyboy help me?

Thanks in advance.

Heinz

[kuba_michalik · Accepted solution]

Unless star symbol is treated completely differently when coming from a Publisher authorization table, I'd be careful with it. For fields NTNAME, USERID, PASSWORD it indeed means "any value at all". For all other fields, it means "any value explicitly specified elsewhere in this table". So  for VERBAND * means GMG (because only GMG is explicitely mentioned), for MODUL * means 3 or 4 or 1, and for GRUPPE it actually means "nothing" (because there is no explicitely specified GRUPPE anywhere in the table).

[jpk]

Hi Everyone

Really great post, most appreciated.

Ebiexperts a Qlik Technology partner has launched an automated Section Access product to the market. 

The product is called SAM: Section Access Manager for Qlik

• Qlik Integrated & Authenticated
• Self-service no-code
• Automation options
• Active Control SingleTouch
• Admin
• E-Learning

This is the MVP release and fully automated. I have attached the brochure.

Regards

JP