topic Re: tab wise security can we provide to developer 1 , developer 2 logins in QlikView

tab wise security can we provide to developer 1 , developer 2 logins

vikasmahajan — Fri, 31 May 2013 06:11:58 GMT

Dear All,

Is there any security is provided by Qlikview to protect tab1 , tab2 used by developer in same qlikview server.

Means if I give access to developer 2 for tab2 then developer 2 will see only tab2 in qlikview development area.

thanks in advance

Vikas

Re: tab wise security can we provide to developer 1 , developer 2 logins

Gysbert_Wassenaar — Fri, 31 May 2013 06:13:45 GMT

No, there isn't. You gave to define it yourself using Section Access. See here for an example.

Re: tab wise security can we provide to developer 1 , developer 2 logins

Fri, 31 May 2013 07:11:50 GMT

Hi Vikas,
Yes u can protect tab1 , tab2 used by developer.

First u need to create a security table

Please find below tables ;

example

SecurityTable:
Load

User Name SHEET1 SHEET2
*                    1             1
Dev1               1             0
Dev2               0             1

Left join

Load
ACCESS      USERID   PASSWORD     User Name        SheetView
ADMIN         qvadmin       123                       *                      *
USER            *                 *                       Dev1             SHEET1
USER            *                 *                       Dev2             SHEET2

Hope above securitytable will work.

regards,

Bika

Re: tab wise security can we provide to developer 1 , developer 2 logins

vikasmahajan — Fri, 31 May 2013 11:07:33 GMT

Thanks , Gysbert there is no option in Qlikview Server for managing the same ?

Vikas

Re: tab wise security can we provide to developer 1 , developer 2 logins

nizamsha — Fri, 31 May 2013 11:12:07 GMT

SECTION Access;

STAR is '*';

LOAD * Inline [

ACCESS,USERID,PASSWORD

ADMIN, ADMIN,ADMIN

ADMIN1,ADMIN1,ADMIN1

USER,USER1,U1

USER,USER2,U2

USER,USER3,U3

USER,USER4,U4

USER,USER5,U5

];

LOAD * INLINE [

USERID,INVESTOR_ID,FUND_ID,COUNTRY_NAME

ADMIN,, ,,,,

ADMIN1,,,,,,

USER1,7,21,UNITED STATES

USER2,7,22,FRANCE

USER2,7,22,HONG KONG

USER3,7,23,CYPRUS

USER3,7,24,HUNGARY

USER3,7,25,JAPAN

USER4,7,24,CANADA

USER4,7,26,LUXEMBOURG

USER4,7,25,JAPAN

USER4,7,28,SINGAPORE

USER4,7,24,NOT DEFINED

];

SECTION Application;

[USER ROLES]:

LOAD * INLINE [

USERID,%ROLE

ADMIN,UNLIMITED

USER1,MANAGER

USER2,CRM

USER3,DEVELOPER

USER4,TESTER

];

[SHEET AUTHORISATION]:

LOAD * INLINE [

%ROLE,SH_SUMM,SH_PERF

UNLIMITED,1,1

MANAGER,1,0

CRM,0,0

DEVELOPER,1,0

TESTER,1,1

];

try this one i hope it will be use ful

Re: tab wise security can we provide to developer 1 , developer 2 logins

Gysbert_Wassenaar — Fri, 31 May 2013 11:14:19 GMT

No, you need to set up section access for the sheets in the document itself. The expressions with the conditions to show/hide the sheets based on the section access table are defined in the document on the sheet properties window.