In one of our apps there is a sheet which includes a few charts and tables (with subsequent calculation expressions). It has some confidential information on cost that I don't want my team to see (it would reveal salaries). Want to avoid creating a copy which I would save in my personal drives so want to see what options are available.
Sheets, Expressions and Charts (& objects in general) all have a property called "Conditional Show". It lets you show/hide objects based on the outcome of an expression. That expression can be tied to Section Access.
But it is not a good idea to hide objects. These are just "windows" to the information behind, and in order to make this scheme work you have to make sure that all relevant objects are hidden and that it is not possible for the user to create additional objects. A better way is to hide the information itself, which you can do through Section Access. In your case you should use OMIT.
you can use section access if a user needs access to a sheet but the data they see needs to be limited.
If you only want certain users to see/not see sheets in their entirety, the easisiest way is to use a conditional on the sheet with the condition as =UPPER(OSuser())='domain name\user name - this will allow only the users listed to see the tab (you can us 'or' to repeat the upper comman for multiple users
.png "Former Employee"){kind=icon}