Section access

[Matt1]

 Dear all,

I already read plenty of posts and tutorials and tried out a lot, but I don't find a solution for my situation:

Situation:

• I have >100 users
  • There are several columns that should be removed (OMIT)
• I have ca. 20 Advanced-Users that should see all of these columns that the users cannot see
  • I've got some files where I need to restrict the content on a column for the advanced users - but the column will be invisible/removed for standard users
    • User A can only see USERGROUP A
    • User B can only see USERGROUP B
    • ....
  • Great would be even, if e.g. User F can also see USERGROUP A+B
• I've got 5 Admins that should see the entire data

Until now I only have it working, that users cannot see specific columns and the advanced users are in the admin group. However, there is data that the advanced users should not see - therefore they should be in the user group - right?

I would address all Advanced Users and Admins with their username, and everyone else should have the "default" user rights with the removed columns.

Thank you so much in advance!

section access;

LOAD * inline [
ACCESS, USERID, RESTRICTION, OMIT
USER, *,*, COLUMN_A
USER, *,*, COLUMN_B

ADMIN, DOMAIN\USERA,*,
ADMIN, DOMAIN\SA_SCHEDULER,*

];

section application;