topic Restriction of Application to various users in QlikView

Restriction of Application to various users

rajtechnocraft — Wed, 10 Aug 2011 13:56:49 GMT

Hi Guys,,

Can i use section application to have access control of applications for various users.

Lets say i have 1 main application and then 3 sub applications.

I want to restrict users having access to each of these sub applications.

Can i achieve this thru section application in QV

Through access point this can be done but is it possible at script level.

Regards

Raj

Restriction of Application to various users

vlad_komarov — Wed, 10 Aug 2011 14:38:59 GMT

You can do it by assigning "Roles":

For example:

Section Access;
LOAD [ACCESS],
     NTNAME,
     SITE,
     ROLE,
     BU,
     MA,
     [GROUP]
FROM
[..\access.xls]
(biff, embedded labels, table is Sheet1$);

Section Application;
ROLES:
LOAD * INLINE [
ROLE, Role
TEST, TEST
ALL, ALL
NHC, NHC
];

And use the ROLE='NHC' to not allow access to specific functionality in your app for users who do not have the NHC flag present in the access.xls file.

Regards,

Vladimir