I have a requirement : When a User logs in he needs to be given access based on a Business Segment .This is true for all sheets except one. When he moves to say Sheet-Exception he needs to view all data. Is this possible? Are there any alternative solutions?
Section Access does not connect to where in the application you will have restriction on what a user might access. Based on Section Access you give access based on rows and fields in the data model. Your data model is fully available on any sheet in the same way.
Could you explain what you mean by exception:
1) Is it an exception to the normal restrictions of what the user can access you mean?
Section Access does not connect to user interface like sheets. So no you can't modify the section access rules when the user moves into another sheet. What is possible to visualize in one sheet will also be possible to visualize in any other sheet.