topic Section Access in QlikView

Section Access

Thu, 25 Apr 2013 07:24:52 GMT

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

Re: Section Access

kuba_michalik — Thu, 25 Apr 2013 07:39:00 GMT

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).

Re: Section Access

jpk — Tue, 07 Sep 2021 11:30:02 GMT

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