Section Access with Reduction Field

[Anonymous]

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;

[Chanty4u]

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;

[Anonymous]

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]

Just add *

[syukyo_zhu]

Hi,

don't forget

star is *;

after

Section Application;

[trdandamudi]

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.

[Anonymous · Accepted solution]

ntname in the section of access‌

I found explanation from this discussion regarding my problem .

[NickP_DF]

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.