Solved

Controlling access to a list

Posted on 2016-09-21
14
72 Views
Last Modified: 2016-10-01
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
0
Comment
Question by:Koen
  • 7
  • 3
  • 2
  • +2
14 Comments
 
LVL 8

Expert Comment

by:Leo
ID: 41809917
0
 
LVL 8

Author Comment

by:Koen
ID: 41810188
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
 
LVL 15

Expert Comment

by:Walter Curtis
ID: 41810632
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
 
LVL 12

Accepted Solution

by:
Ramkisan Jagtap earned 500 total points
ID: 41810642
0
 
LVL 8

Author Comment

by:Koen
ID: 41810660
I will test sharepoint designer tomorrow... will let you know how that goes.
0
 
LVL 5

Expert Comment

by:Isaac
ID: 41811360
Follow "SneekCo" suggestion and look for this image
EditMyItem
0
 
LVL 8

Author Comment

by:Koen
ID: 41812381
@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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 15

Expert Comment

by:Walter Curtis
ID: 41812458
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
 
LVL 8

Author Comment

by:Koen
ID: 41813648
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
 
LVL 12

Expert Comment

by:Ramkisan Jagtap
ID: 41815861
please check the following article to create the workflow:

http://spcycle.blogspot.fi/2012/01/how-to-create-workflow-to-change-item.html
0
 
LVL 8

Author Comment

by:Koen
ID: 41817415
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
 
LVL 8

Author Comment

by:Koen
ID: 41817732
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
 
LVL 15

Expert Comment

by:Walter Curtis
ID: 41817796
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
 
LVL 8

Author Closing Comment

by:Koen
ID: 41825017
Although the problem is only half solved, the answer from ramkisan pointing towards the SP desinger brought me closer to solving my issue
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now