Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Arjunarao
Honored Contributor II

Admin user should access NULL values

Hi All,

I have a report. Users should be access data based on DNAME.

User1 (ADMIN) should access all the data - ACCOUNTS,HR,SALES.

User2 should access HR data.

User 3 should access SALES data.

But User1 should access NULL values always.

Please update the attached file and provide.

Thanks in advance.

1 Solution

Accepted Solutions
MVP
MVP

Re: Admin user should access NULL values

Hi,

If user wants to access all the values other than then use *, to access nulls just give empty.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,DNAME

    ADMIN,ADMIN,ADMIN,*                // Access all values other than Nulls

    ADMIN,USER1,USER1,                   // To access values

    USER,USER2,USER2,HR

    USER,USER3,USER3,SALES

     USER,USER4,USER4,*

     USER, USER4, USER4, // USER4 can Access all values including nulls     

];

Section Application;

Hope this helps you.

Regards,

Jagan.

4 Replies
antoniotiman
Honored Contributor III

Re: Admin user should access NULL values

HI,

see attachment

Users/Psw

ADMIN/ADMIN

USER1/USER1

USER2/USER2

USER3/USER3

Regards,

Antonio

Arjunarao
Honored Contributor II

Re: Admin user should access NULL values

Hi AntonioTiman

Thank you so much.It is perfect.

MVP
MVP

Re: Admin user should access NULL values

Hi,

If user wants to access all the values other than then use *, to access nulls just give empty.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,DNAME

    ADMIN,ADMIN,ADMIN,*                // Access all values other than Nulls

    ADMIN,USER1,USER1,                   // To access values

    USER,USER2,USER2,HR

    USER,USER3,USER3,SALES

     USER,USER4,USER4,*

     USER, USER4, USER4, // USER4 can Access all values including nulls     

];

Section Application;

Hope this helps you.

Regards,

Jagan.

Arjunarao
Honored Contributor II

Re: Admin user should access NULL values

Hi jagan

Thank you so much. It is working for NULLs also.

Community Browser