I already read plenty of posts and tutorials and tried out a lot, but I don't find a solution for my 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.