Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnamraju513
Creator
Creator

Section Access with Reduction Field

Hi All ,

I have a Reduction field name "COM_CODE" which has around 450 rows of data in it .

I've to create section access for this case to restrict USER to see only certain COM_CODE values .

But for ADMIN Access i need to show all 450 rows of data . So, what should i enter in reduction field for ADMIN ?

Should I enter * or BLANK .

My Section Access Script is :

Section Access;

Load * INLINE

[

ACCESS , NTNAME ,COM_CODE

ADMIN , ABC\qvadmin

ADMIN , ABC\123

ADMIN , ABC\456

USER , ABC\789 , 0001

USER , ABC\789 , 0002

USER , ABC\789 , 0003

USER , ABC\789 , 0004

USER , ABC\789 , 0005

];

Section Application;

1 Solution

Accepted Solutions
krishnamraju513
Creator
Creator
Author

ntname in the section of access


I found explanation from this discussion regarding my problem .

View solution in original post

7 Replies
Chanty4u
MVP
MVP

just add * for all admin

Section Access;

Load * INLINE

[

ACCESS , NTNAME ,COM_CODE

ADMIN , ABC\qvadmin ,*

ADMIN , ABC\123 ,*

ADMIN , ABC\456,*

USER , ABC\789 , 0001

USER , ABC\789 , 0002

USER , ABC\789 , 0003

USER , ABC\789 , 0004

USER , ABC\789 , 0005

];

Section Application;

krishnamraju513
Creator
Creator
Author

But if i use * for admin , it will only capture the COM_CODE values defined in Section Access Script .

I need ADMIN to Capture all 450 values in COM_CODE field .

trdandamudi
Master II
Master II

Just add *

syukyo_zhu
Creator III
Creator III

Hi,

don't forget

star is *;

after

Section Application;

trdandamudi
Master II
Master II

When you use * it will not restrict the values. It will show all the 450 values for ADMIN. If you still think there is an issue can you please share a sample app.

krishnamraju513
Creator
Creator
Author

ntname in the section of access


I found explanation from this discussion regarding my problem .

View solution in original post

NickP_DF
Creator
Creator

Hello guys,

what about if I need to allow a user (not admin) to see all the 450 values in COM_CODE field?

Is there a way to avoid the list of all them and then the "*" grant?

Thanks.