topic Re: Sheets security on user groups in QlikView

Sheets security on user groups

Tue, 06 May 2014 09:47:39 GMT

Hi all.

I would like to use sheets security on a applikation and I use user groups beacuse I have amny users.

How to solve this and what is the best way to hide sheets is it with section access or is ther any other solutions what doesn't needs to use userid and password?

Thanks!

Re: Sheets security on user groups

Anonymous — Tue, 06 May 2014 10:00:10 GMT

Hi,

http://community.qlik.com/docs/DOC-1853

http://community.qlik.com/docs/DOC-6417

Hope this helps

Re: Sheets security on user groups

vikasmahajan — Tue, 06 May 2014 10:28:31 GMT

PFA Documentation with demo.

Vikas

Re: Sheets security on user groups

Wed, 07 May 2014 07:49:04 GMT

The question is, could I use this in my script and the use the show sheet conditional as sum(SH01)>=1 on each sheet. I would like to use NTNAME and is it possible to use groups?

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, ABA/tonys

USER, ABA/app-qlikview-bi-controller

USER, ABA/app-qlikview-bi-leader

];

Section Application;

LOAD * INLINE [

NTNAME, Sheets, Flag

ABA/tonys,SH67, 1

ABA/tonys,SH105, 1

ABA/tonys,SH108, 1

ABA/tonys,SH111, 1

ABA/tonys,SH110, 1

ABA/app-qlikview-bi-controller,SH67, 1

ABA/app-qlikview-bi-controller,SH105, 1

ABA/app-qlikview-bi-controller,SH108, 1

ABA/app-qlikview-bi-controller,SH111, 0

ABA/app-qlikview-bi-controller,SH110, 0

ABA/app-qlikview-bi-leader,SH67, 1

ABA/app-qlikview-bi-leader,SH105, 1

ABA/app-qlikview-bi-leader,SH108, 1

ABA/app-qlikview-bi-leader,SH111, 1

ABA/app-qlikview-bi-leader,SH110, 0

];

Re: Sheets security on user groups

Wed, 07 May 2014 07:55:08 GMT

hi please check this appln

Re: Sheets security on user groups

Wed, 07 May 2014 09:39:06 GMT

My script looks like below but I don´t get any prompt when I relaod och publish.

Do I need to do anything in the QMC?

SECURITY:

LOAD * INLINE [

ACCESS, NTNAME, USER, PASSWORD

ADMIN, ABA/tonys, ADMIN, ADMIN

USER, ABA/app-qlikview-bi-controller, SC, SC

USER, ABA/app-qlikview-bi-leader, SLG, SLG

];

Section Application;

SHEET_ACCESS:

LOAD * INLINE [

USER, SHEET1, SHEET2, SHEET3, SHEET4, SHEET5, SHEET6, SHEET7, SHEET8, SHEET9, SHEET10, SHEET11, SHEET12, SHEET13, SHEET14

ADMIN, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1

SC, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1

SLG, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1

];