I am in the process of implementing Section Access on a document that we are releasing shortly. We have tested and have it working for users with only 1 Group (the field we are restricting data by). However, have users that require access to multiple Groups and a few super users that should have access to all Groups. I am using the following code in my script:
SECTION ACCESS;
LOAD
ACCESS,
Upper(USERID) as NTNAME,
Upper(Group) as GROUP
FROM
.\Section Access Setup File.xlsx
(ooxml, embedded labels, table is Sheet1);
And in the file I have the following:
| USER | test1 | Group1 |
| USER | test2 | Group2 |
| USER | test3 | Group1,Group2 |
| | |
I know that * is used to denote all options that have been used, but if we don't have a user assigned to every Group I still want my super users to see ALL Groups, so what is the syntax for this, is it 'ALL'?
Does the 'Group1,Group2' syntax work for a user with access to multiple Groups?
.png "Former Employee"){kind=icon}