Qlik: Section Access Issue

[#1]

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.

[Ronnie_Taborn]

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

[rwunderlich · Accepted solution]

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

[#4]

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

[rwunderlich]

Yes, the reloading userid should be an ADMIN.

-Rob

[#6]

Thanks for the confirmation