Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Murray
Contributor
Contributor

How to setup Section Access on a Direct Query App

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?
Labels (1)
2 Replies
catarina1911
Contributor II
Contributor II

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

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com