I have a table with only 2 views. One is “Master” and is a personal view, and the other one is just a duplicate of “Master”, but with hidden columns, and it’s a locked view.
The idea was: Managers use the “Master” personal view, with all the information exposed, and our contractors use the duplicated locked view, with hidden columns (naturally they have a different login). Since they can’t unhide the columns, we thought this would prevent them from seeing sensible information.
However, when contractors duplicate the “Duplicate” view (as a personal view, or collaborative view), they are able to unhide the columns and see the sensible information.
Is this the expected behaviour? If so, what’s the best way to prevent contractors from accessing sensible information?