topic Re: Qlik: Section Access Issue in QlikView

Qlik: Section Access Issue

Tue, 26 Aug 2014 16:57:31 GMT

Hi,

I have section access in the following format:

Section Access;

USER_DIM:

LOAD 'USER' as ACCESS,

USER_NAME as NTNAME,

USER_GROUP as PROJECT

FROM

....\user.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

CONCATENATE

LOAD * INLINE [

ACCESS, NTNAME, PROJECT

'ADMIN', 'MyUser',*

];

Section Application;

'MyUser' exists on the user.txt file as well. Am i doing this right?

After the initial load, the file fails to load again and I have to redeploy the app from local directory. I assume section access is causing problems. The file security is as below:

Just wanted to check if the security is okay.

Re: Qlik: Section Access Issue

Ronnie_Taborn — Tue, 26 Aug 2014 17:11:08 GMT

http://community.qlik.com/docs/DOC-1853

Re: Qlik: Section Access Issue

rwunderlich — Tue, 26 Aug 2014 17:28:43 GMT

MyUser should not be in both the user.txt and the INLINE, because then it is being defined as both USER and ADMIN, which is incorrect.

-Rob

Re: Qlik: Section Access Issue

Tue, 26 Aug 2014 18:05:01 GMT

Hello Sir Rob,

I am truly honoured that you have responded to my query.

I had suspected that as an issue and would test the suggested alternate at the first opportunity. I am however trying to automate QV reload using command line utilities but I have a doubt: the user that runs the reload script, does it need to be an Admin on the app? I guess I know the answer but am looking for 2nd opinion.

Kind Regards

SNC

Re: Qlik: Section Access Issue

rwunderlich — Tue, 26 Aug 2014 18:37:36 GMT

Yes, the reloading userid should be an ADMIN.

-Rob

Re: Qlik: Section Access Issue

Tue, 26 Aug 2014 19:42:36 GMT

Thanks for the confirmation