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

[vikasmahajan]

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

[Gysbert_Wassenaar]

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

[#3]

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

[vikasmahajan]

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

Vikas

[nizamsha]

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

[Gysbert_Wassenaar]

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.