There is none. The "*" in the section access table stands for all values listed under that field in the section access table, not in the data model, so in your example, values 1 and 2 for REDUCTION.
You will need to loop through all possible values, maybe for an ADMIN access, to make the "*" meaning "all possible values".
Admins: // Table label for identification purposes, does not have a meaning or use here as it cannot be referred after the "section application" line
'ADMIN' AS ACCESS,
'INTERNAL\SA_SCHEDULER' AS USERID
FROM Reduction.qvd (qvd); // whichever the source of REDUCTION field is
Note that section access can work at any point in the script, you can use RESIDENT to populate the section access table.
thanks Miguel and Pankay,
Following you indication my final script works.
in the concatenate part I added a general user with all combination then in the S1 inline table I will add manually each user.
My next step will be how to import automatically the user defined on the stream into the Section App, but I will open another thread.
LOAD * inline [
ACCESS, USERID,REDUCTION, OMIT
'ADMIN' as ACCESS,
'INTERNAL\SA_SCHEDULER' as USERID,
WSN_ID as REDUCTION
WSN_ID as REDUCTION,