Lists user permit - Hiding lines to selected users

%3CLINGO-SUB%20id%3D%22lingo-sub-2443822%22%20slang%3D%22en-US%22%3ELists%20user%20permit%20-%20Hiding%20lines%20to%20selected%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2443822%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20do%20the%20following%3A%20I%20would%20like%20to%20have%20a%20list%20with%20several%20users%20with%20editing%20permit%2C%20but%20I%20need%20them%20to%20only%20read%2Fedit%20selected%20items%2Flines.%20The%20point%20is%20that%20this%20selected%20items%2Flines%20are%20not%20only%20the%20ones%20created%20by%20them.%20So%20I%20need%20that%20user%20A%20can%20read%2Fedit%20items%2Flines%20created%20by%20user%20A%20and%20user%20B%2C%20but%20not%20the%20ones%20created%20by%20user%20C%2C%20as%20an%20example.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20limit%20the%20access%20by%20item%2Fline%20to%20each%20user%2C%20because%20there%20are%20too%20many%20lines%20to%20do%20it%20by%20hand.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20goes%20my%20%22not%20really%20strong%22%20solution%3A%20the%20list%20(i)%20I%20am%20working%20to%20has%20a%20look%20up%20value%20that%20is%20linked%20with%20another%20list%20(ii).%20This%20linked%20list%20(ii)%20is%20a%20summary%20of%20projects%20and%20I%20can%20use%20those%20projects%20to%20limit%20the%20access%20of%20the%20users%2C%20so%20users%20A%20and%20B%20can%20only%20access%20to%20project%201%2C%20user%20C%20can%20only%20access%20to%20project%202%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20make%20this%20happen%20I%20have%20done%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20In%20the%20linked%20list%20(ii)%20I%20have%20limited%20the%20access%20(all%20access)%20to%20every%20project%20(item%2Fline)%20to%20the%20users%20I%20want%2C%20so%26nbsp%3Busers%20A%20and%20B%20can%20only%20access%20to%20project%201%2C%20user%20C%20can%20only%20access%20to%20project%202%2C%20etc.%3C%2FP%3E%3CP%3E2)%20In%20the%20main%20list%20(i)%20I%20have%20a%20look%20up%20column%20to%20list%20(ii)%20with%20relationship%20behavior.%3C%2FP%3E%3CP%3E3)%20I%20created%20a%20view%20for%20the%20list%20(i)%20where%20you%20can%20only%20see%20the%20items%20if%20the%20look%20up%20column%20has%20content%3B%20it%20is%20not%20blank.%20In%20addition%2C%20I%20have%20deleted%20the%20rest%20of%20the%20views%20and%20let%20this%20one%20as%20the%20only%20one.%3C%2FP%3E%3CP%3E4)%20I%20remove%20the%20permits%20to%20create%20or%20edit%20any%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20confident%20that%20this%20prevent%20to%20use%20a%20back%20door%20to%20access%20to%20the%20hidden%20data.%20Do%20you%20know%20if%20there%20is%20another%20way%20to%20do%20it%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2443822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hello guys,

 

I am trying to do the following: I would like to have a list with several users with editing permit, but I need them to only read/edit selected items/lines. The point is that this selected items/lines are not only the ones created by them. So I need that user A can read/edit items/lines created by user A and user B, but not the ones created by user C, as an example. 

 

I cannot limit the access by item/line to each user, because there are too many lines to do it by hand.

 

Here goes my "not really strong" solution: the list (i) I am working to has a look up value that is linked with another list (ii). This linked list (ii) is a summary of projects and I can use those projects to limit the access of the users, so users A and B can only access to project 1, user C can only access to project 2, etc.

 

To make this happen I have done the following:

 

1) In the linked list (ii) I have limited the access (all access) to every project (item/line) to the users I want, so users A and B can only access to project 1, user C can only access to project 2, etc.

2) In the main list (i) I have a look up column to list (ii) with relationship behavior.

3) I created a view for the list (i) where you can only see the items if the look up column has content; it is not blank. In addition, I have deleted the rest of the views and let this one as the only one.

4) I remove the permits to create or edit any view.

 

I am not confident that this prevent to use a back door to access to the hidden data. Do you know if there is another way to do it? 

 

Thanks in advance.

0 Replies