Controlling access to a list

I have a list on sharepoint online, which holds info about users.
I would like the users to only have (read/write) access to their own (only 1) item in the list.

I tried this manually and it seems to work, but I'd need a way of setting it automatically (once for all items) when I upload them (initial load)

thanks
LVL 9
KoenChange and Transition ManagerAsked:
Who is Participating?
 
Ramkisan JagtapConnect With a Mentor Lead DeveloperCommented:
0
 
KoenChange and Transition ManagerAuthor Commented:
no, not really, it explains how to create and set rights using the sharepoint interface...(i know how to do that).
I'm looking for a way to either apply specific rights on specific list items (using a field from the item) in bulk on a big list (sharepoint script/code/workflow/...)
or alternatively
creating the list items in an automated way (e.g. vba - I can do that), and set the rights for each of these items automatically at the same time (through coding)
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Walter CurtisSharePoint AEDCommented:
Under list settings --> advanced settings you can determine what type of access users have to the items. That may meet your needs...

Hope that helps...
0
 
KoenChange and Transition ManagerAuthor Commented:
I will test sharepoint designer tomorrow... will let you know how that goes.
0
 
IsaacSharePoint Client Side DeveloperCommented:
Follow "SneekCo" suggestion and look for this image
EditMyItem
0
 
KoenChange and Transition ManagerAuthor Commented:
@Isaac and SneekCo

Hi, the settings looked promising...(and easy mainly)
Except, the creator of the items is the user who did the bulk upload, not the user who the line item is about...
So that does not help (unless if there is an easy trick to change the creator)

Checking the designer approach now...
0
 
Walter CurtisSharePoint AEDCommented:
Thanks for the feedback. The designer approach works well, I have used it often. For you bulk upload you may want to use a workflow that sets the permissions, but also use the settings because the workflow is not %100 as the settings are. Although the chance or a workflow failing are slim, it could happen so I try to avoid points of failure and risks as much as possible.

Another , maybe more important questions may be, what are you trying to do? Using unique or granular permissions is not a great thing to do. If this is sensitive data, this is not a good thing at all, so give that some consideration also.

Good luck...

@Issac - thanks for the feedback.
1
 
KoenChange and Transition ManagerAuthor Commented:
it is a subscribe list (to some news info concerning specific location),people can adapt the location and whether they want Y/N receive info on that location.
We want them to update it themselves, but of course not change other peoples entries.

I cannot get the designer workflow to work...(but I have not a lot of experience with SP designer workflows, so it's probably me). Could someone elaborate on how to configure the workflow.
0
 
Ramkisan JagtapLead DeveloperCommented:
please check the following article to create the workflow:

http://spcycle.blogspot.fi/2012/01/how-to-create-workflow-to-change-item.html
0
 
KoenChange and Transition ManagerAuthor Commented:
Thanks allready for the follow up...

I built the workflow, but i cannot publish it (error)...

I've stripped it down to a simple
replace rights on the current item giving me 'full control' (no variabels yet), still the same error

"Errors were found when compiling the workflow. The workflow files were saved but cannot be run."

I'm stumped... :-(
0
 
KoenChange and Transition ManagerAuthor Commented:
OK... some further investigation results in some intresting finds and (of course) new questions...

I have tried it on our SP 2013 farm and there I am able to publish the workflow. I can launch it on the individual items and it works...
Now I need to be able to run it on all items (automatically) and on SP online...

Keep you posted
0
 
Walter CurtisSharePoint AEDCommented:
Looks like you are making progress. If this question has morphed from being about access to being about workflows, maybe close this questions and open a new question about workflows. In that way you will bring in more workflow expertise.

Good luck...
0
 
KoenChange and Transition ManagerAuthor Commented:
Although the problem is only half solved, the answer from ramkisan pointing towards the SP desinger brought me closer to solving my issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.