1 Reply Latest reply: Sep 21, 2012 7:50 AM by Brian Rzeznik RSS

    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 :-)