topic Re: Section Access in QlikView

Section Access

swati_rastogi27 — Thu, 23 Jun 2016 09:48:27 GMT

Hi ,

I have a requirement where I want to give full access(equivalent to admin) to 1 particular user.

In underlying database table, I cannot specify the access level as 'admin' because of some internal policy violation issues.

How can I achieve this in section access, because if I read the ACCESS as 'user' , he is unable to perform admin level tasks like edit script etc.

Re: Section Access

Peter_Cammaert — Thu, 23 Jun 2016 09:54:10 GMT

Aha, a deadlock ! A developer should be able to modify everything in a QVW document, but he/she is not allowed to see the actual data.

IMHO there is only one solution: separate the development environment (with test data to which no restrictions apply) from the environment with real policy-controlled data.

Peter

Re: Section Access

avinashelite — Thu, 23 Jun 2016 10:13:45 GMT

if its for only one user then you could add a IF condition like this

SECTION ACCESS;

LOAD

if(user='ABC','ADMIN',ACCESS) as ACCESS,

NTNAME