topic Section Access with NTNAME doesn't work with * in QlikView

Section Access with NTNAME doesn't work with *

Fri, 21 Sep 2012 11:07:11 GMT

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 🙂

Re: Section Access with NTNAME doesn't work with *

Fri, 21 Sep 2012 11:50:34 GMT

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