How to setup Section Access on a Direct Query App

[Murray]

I've been able to setup Section access on a non-direct-query app and works fine.

I now have a need to do the same on a direct query app but it does not work with the exact same method used.

Here is an example with a fake email.

Section Access;

entitlement_data:
load * inline [
ROLE ,USEREMAIL ,NUMBER
ADMIN ,tester@email.com ,
];

SectionAccess:
NOCONCATENATE LOAD
UPPER(ROLE) AS ACCESS,
UPPER(USEREMAIL) AS USER.EMAIL,
SUBFIELD(NUMBER,'|') AS ACCOUNT_ID
RESIDENT entitlement_data;

drop table entitlement_data;

When I Load data I get this message:

Started loading data

Operation aborted

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

The Data connection works fine and I have many tables mapped and they have the upper case ACCOUNT_ID in them.

Is this doable in Direct Access?

[catarina1911]

hello,

were you able to find a solution for this problem?

thank you,

Catarina

[marksouzacosta]

As far as I recall, Section Access is not supported in Direct Query apps. The documentation doesn't explicitly state this, but it does mention that "Security is handled by the database":
Direct Query limitations | Qlik Cloud Help

Regards,

Mark Costa