I have a scenario like this, I have a component module with a component list in a row as A(parent), (A1, A2, A3 are children) & B(Parent), (B1, B2, B3 are the children). I too have 2nd module with data like this, Area & Components are in a row time and line items are in a column and the line items are PY year(formula), Adjustment(input) & CY(formula)...
I have given the synchronize selection between the 1st module & 2nd module to the components, eg: if I can select component A in my 1st module I can see only A component and its associates(A1, A2, A3) in my 2nd module successfully.
Now I would like to give access to users who belong to the respective components can only do read or write the adjustments(line item) in the second module based on the component selection in my 1st module and all components A, B, C so on... can be visible to all but the users who have access to the components can access the module based on their accessibility(read or write).
eg: 1. If a user has access to component A with read access that the user can see only the component A and its associates and do not do any input or edit to the 2nd module especially do not input any value to the line item(adjustment).
2. If the same user have the access to component B with write access that the user can see only component B and its associates and can input or edit to the 2nd module.
I did with selective access but I would like to do it with dynamic cell access because, with selective access, it can be at the list items level to the users whom we are given/selected to the selective list items but for other users, who do not have this accessibility can at least see the components. so this kind of requirement can not only work with selective access.
Deciding between using Selective Access and Dynamic Cell Access is always tricky. The main question I always ask is, "Is this security setting just for this module or should it be a global setting?" If global, then Selective Access is the way to go vs. if it is just for a certain module, then DCA is the way to go. Remember, DCA is not true security, it just allows you to hide values, make values read only, or make the value editable at the line item level, not the hierarchy level.
If I am understanding you correctly, you can definitely use DCA for this. My understanding is this, please correct me if I am wrong:
ability to set values to be read or write enabled by the user
Not necessarily hiding the hierarchy members (Selective Access), but the values within the line item.
all values should be read, but if they have write in the first intersection, they can write in this module. Correct?
If those are correct assumptions, you can define different DCA permissions for the different modules. Create a DCA module defined by components and Users with line items
Read - boolean formatted with formula = Not Write
Write - boolean formatted, no formula, just an input by the Admin
Note, if you want the read/write access to bubble up to the Area (parent of components), change the summary of the line items to ANY. For the line items in the Modules 1 and Modules 2, do what @Misbah stated and define the proper read/write access to the correct driver.
Now, if you want to jazz it up a little where Module 2 is only Read access for everyone, you have a third boolean in the DCA module name Always Read (boolean formatted) with formula of TRUE. Update the DCA Read Driver for the line items in the 2nd module to the Always Read boolean.