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.
reshmakala
Contributor III

Section Access for all the values (*)

Hi all,

I am trying to implement section access on a field with NTNAME. Here is my script

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1,

ADMIN, USER2,

USER, USER3, A

USER, USER4, B ];

This works perfectly fine on desktop. When I publish this on Server, it says "Failed to open document. Access denied". When tried putting in a value for FIELD beside Admin, I can see the data related to that value or else the access is denied. I cannot manually include all the values for FIELD as I have few hundreds. How can I specify ALL values for Admins. Using * is giving me only A and B access.

Thank you.

1 Solution

Accepted Solutions
krishnacbe
Valued Contributor III

Re: Section Access for all the values (*)

Hi,

You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

Hope below example will give you details.

Section_Access_Table:

Load

'ADMIN' as ACCESS,

'ADMIN' as NTNAME,

*;

SQL select distinct FIELD from Table_Name;

concatenate

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1, *

ADMIN, USER2, *

USER, USER3, A

USER, USER4, B ];

Section Access;

Load * from Section_Access_Table;

Section Application;

2 Replies
krishnacbe
Valued Contributor III

Re: Section Access for all the values (*)

Hi,

You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

Hope below example will give you details.

Section_Access_Table:

Load

'ADMIN' as ACCESS,

'ADMIN' as NTNAME,

*;

SQL select distinct FIELD from Table_Name;

concatenate

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1,

ADMIN, USER2,

USER, USER3, A

USER, USER4, B ];

Section Access;

Load * from Section_Access_Table;

Section Application;

krishnacbe
Valued Contributor III

Re: Section Access for all the values (*)

Hi,

You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

Hope below example will give you details.

Section_Access_Table:

Load

'ADMIN' as ACCESS,

'ADMIN' as NTNAME,

*;

SQL select distinct FIELD from Table_Name;

concatenate

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1, *

ADMIN, USER2, *

USER, USER3, A

USER, USER4, B ];

Section Access;

Load * from Section_Access_Table;

Section Application;

Community Browser