Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access

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

1 Solution

Accepted Solutions
kuba_michalik
Partner - Specialist
Partner - Specialist

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

View solution in original post

2 Replies
kuba_michalik
Partner - Specialist
Partner - Specialist

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
Partner - Creator II
Partner - Creator II

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