Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Section Access SQL

Hello

Initially sorry for the language, but I am Brazilian.

I'm testing a QV with Section Access which works normally if I do the load through Load InLine, but when I load the data from Section Access via SQL it does not open, saying I have no access to the file.

Have I made sure that the SQL statement returns the same data EXACTLY Load InLine command. Has anyone gone through this problem?

Below is the example I'm testing:

Dont Work

SECTION Access;

SQL

  Select 'ADMIN' as ACCESS,

            'Administrator' as NTNAME,

            '1' as LINK;

Work

SECTION Access;

LOAD * INLINE [

    ACCESS, NTNAME, LINK

    ADMIN, Administrator, 1

];

Help-me Please!

Tags (3)
2 Replies
Not applicable

Re: Section Access SQL

Discovered!

When performing the load via SQL users need to convert user names to uppercase, with the function UPPER

Descobri!!!

Ao realizar a carga dos usuários via SQL é preciso converter o nome dos usuários para letras maiusculas, com a função UPPER

Not applicable

Re: Section Access SQL

Hi Anderson,

                  You must change them to upper case to work in section access, because section access allows only uppercase data as per qlikview standards.

thank you.

Community Browser