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: 
Not applicable

Section Access with NTNAME doesn't work with *

Good mornig,

i should done some test to convert report from plugin to AJAX.

I have a problem with section access:

if in SECTION ACCESS i write:

SQL SELECT

LOWER(cutenti) AS "NTNAME"

,'USER' as "ACCESS"

,commoper as JOB

from GenAnag.User_All_jobs

UNION

select     'saco6071' as NTNAME,'ADMIN' AS "ACCESS",'00001' AS JOB FROM DUAL;

when I try to open a Report from AJAX console with saco6071  credential it works OKù(only 00001 JOB is visible)

while if i Write:

SQL SELECT

LOWER(cutenti) AS "NTNAME"

,'USER' as "ACCESS"

,commoper as JOB

from GenAnag.User_All_jobs

UNION

select     'saco6071' as NTNAME,'ADMIN' AS "ACCESS",'*' AS JOB FROM DUAL;

when I try to open a Report from AJAX console with saco6071  credential i can't access to report(while if i open report directly from qlikview works.i see all Job)

someone can help me or have any ideas?

many thanks and best regards 🙂

1 Reply
Not applicable
Author

i chek the Strictly exclusion and works!:-) many thanks!