Section access control load resident table

[vvvvvvvvvv]

How to load resident table to be the section access?

I wrote the following

section access;
ACCESS_CONTROL:
load * resident TESTING;
section application;

While TESTING table :

When load data , the following error appear.......

Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.

Data has not been loaded. Please correct the error and try loading again.

[miskinmaz]

It means in your testing table the user (one you are using for development is not there in the list).

[vvvvvvvvvv]

but the one I am using for development is in the list-------istest119

[miskinmaz]

Just cross check that the users directory is used in testing table is correct.

Also not sure but there are two lines for the development user. Remove the one with * and try.

[vvvvvvvvvv]

Error still exist

[marcus_sommer]

Try it with:

section access;
ACCESS_CONTROL:
NOCONCATENATE load * resident TESTING;
section application;

drop tables TESTING;

If you need the table TESTING for anything change the fieldnames to make sure that there is no connection to the section access table.

Don't forget to ensure to have BACKUP's from the application to not to risk to lose your work.

- Marcus

[vvvvvvvvvv]

does not work ...

error still exist

[vvvvvvvvvv]

any updates??

[vvvvvvvvvv]

I load the section access directly by load inline is work:

section access;
TESTING:

LOAD * INLINE [
ACCESS,USERID,SCHL
ADMIN,UST_LDAP\istest119,A
ADMIN,UST_LDAP\istest119,B

];

section application;

BUT.....load * resident table whose content are same as inline data 

'Access was denied after reload. Check that the user that reloads the script is included in the section access part of the script.' will be thrown!

[eduardo_palacios · Accepted solution]

Hi, try UPPERCASE all fields in Resident command:

section access;
ACCESS_CONTROL:
load 

UPPERCASE(ACCESS) as ACCESS,

UPPERCASE(USERID) as USERID,

UPPERCASE(SCHL) as SCHL

resident TESTING;
section application;

//(don't forget to drop temp table "TESTING").

DROP TABLE TESTING; 

in qlik documentation there's the following:

"**Note that all data loaded via an external data source must be loaded in upper case in the SECTION ACCESS statement. This does not apply to INLINE data which always will be treated as upper case."

Hope it helps.