topic Re: How to reduce data for ADMIN ACCESS in Section Access script? in QlikView

How to reduce data for ADMIN ACCESS in Section Access script?

sanchayan — Sun, 28 May 2017 21:33:13 GMT

In section access, how can I reduce data in such a way that account with ADMIN access will also view reduced data (some fields will be restricted to ADMIN access) ?

Whether data reduction is possible for ADMIN access? If possible then how shall I write that section access script?

Does OMIT field omit a field only for USER view or for ADMIN view as well?

Regards,

Sanchayan

Re: How to reduce data for ADMIN ACCESS in Section Access script?

prieper — Mon, 29 May 2017 08:15:12 GMT

Think that ADMIN must have unlimited access.

Application can only be reloaded by users with ADMIN-priviliges. This user cannot be restricted, as the file is saved with the fields, for which this particular user is allowed.

Other users may be restricted (probably for the purpose of editing/changing code), however application then will have to be refreshed by the a.m. Super-ADMIN.

Script would only add this field with the contents:

SECTION ACCESS;
LOAD * INLINE [
    ACCESS, NTNAME, OMIT
    ADMIN, A
    ADMIN, B, SECRETFIELD
    USER, C, SECRETFIELD
    USER, C
];
SECTION APPLICATION;

Peter

Re: How to reduce data for ADMIN ACCESS in Section Access script?

sanchayan — Mon, 29 May 2017 08:26:26 GMT

Hi Peter,

As per your section access script, USER A with admin privilege has no restriction but, will USER B also have no restriction as he has ADMIN privilege or is it that <SECRETFIELD> will be absent in USER B's document view?

Regards,

Sanchayan