Complex Section Access Solution

[Anonymous]

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?

[devarasu07]

Hi,

You can try to combine Data reduction with object level then it might work. give a try

also check this section access collection info.

Section Access

in this above link there bypass section access method u can check that option as well. thanks

Thanks

Deva

[devarasu07]

hi,

refer to the attachment, u can try use "initial selection based on section access" option

download the app try with user

COUNTRY, USERID,PASSWORD,ACCESS
INDIA, DEVA,ADMIN123,USER
SINGAPORE, RAM,ADMIN123,USER
*,ADMIN,ADMIN45,ADMIN

Thanks,Deva

[avinashelite]

Section access will reduce the data based on the login user id , in your case on of the sheet need to show all the data which will be against the section access reduction logic , we could handle this 2 ways

1.for the common data set where you don't want to reduce the data create it as a separate table and add that data to that sheet so full data will be available

2.Make 2 apps . A> with the section access hiding the sheets

                           B > without section access showing all the data

to navigate from A to B add the button to document chain so that   end user does not know he is different app for the common data

Hope this helps you