Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Controlling access to a list

Posted on 2016-09-21
14
Medium Priority
?
86 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
  • 2
  • +2
14 Comments
 
LVL 9

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 19

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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 12

Accepted Solution

by:
Ramkisan Jagtap earned 2000 total points
ID: 41810642
0
 
LVL 9

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 9

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
 
LVL 19

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 9

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 9

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 9

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 19

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 9

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

670 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