Permission & Access Issues

How to Grant Item-Level Edit Permissions in a SharePoint List

Amos Gikunda Sep 29, 2026 868 views

Question details

The user needs to allow specific users to edit selected SharePoint list items created by others, bypassing the list's default restriction that only allows editing their own items.

How to Grant Item-Level Edit Permissions in a SharePoint List

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: A SharePoint list is configured to only allow users to edit items they created. The administrator needs to grant specific users the ability to edit selected items created by other users without giving them access to edit every item in the list.
Observed behavior: Individual item permissions do not override the list-level setting. Users with Contribute or Edit permissions cannot edit items created by others, even if they are granted direct edit permissions on those specific items.

Before you start

Ensure you have Site Owner or Full Control permissions on your SharePoint site to modify list settings, change user permission levels, and break item role inheritance.

Solution 1Recommended

Grant Design Permissions and Break Item Inheritance

Use this method for lists with a small number of items. By granting a higher permission level, users can bypass the restriction, and you can manually secure the items they should not edit.

SharePoint item-level settings apply strictly to users with Contribute or Edit access. Granting a user Design or higher permissions overrides this restriction, allowing them to edit all items. To prevent them from editing everything, you must manually break inheritance on the items they should not touch.

Grant Design Permissions

Navigate to the SharePoint list, click on 'Settings' (gear icon), select 'List settings', and go to 'Permissions for this list'. Grant the target user the 'Design' permission level.

Locate Restricted Items

Go back to the list view and identify the specific items that this user must NOT be allowed to edit.

Manage Item Access

Select an item, click the vertical ellipsis (three dots), choose 'Manage Access', and then click on 'Advanced' at the bottom of the panel.

Break Inheritance

Click 'Stop Inheriting Permissions' in the ribbon to break the permission inheritance from the parent list.

Assign Read Access

Select the target user, click 'Edit User Permissions', and change their permission level from 'Design' to 'Read' for this specific item.

Grant Design Permissions and Break Item Inheritance

Maintenance Consideration: This manual approach is only recommended for lists with very few items, as managing unique permissions manually on a per-item basis can become tedious and difficult to track over time.

Solution 2

Automate Item Permissions with Power Automate

Ideal for lists with a large number of items where manual permission adjustments are impractical or prone to human error.

Free Microsoft Office alternative

Analyze and Manage Exported List Data with WPS Office

While SharePoint is required for managing online list permissions and access control, analyzing and archiving large amounts of list data is often easier locally. You can export your SharePoint lists to Excel formats and seamlessly manage them using WPS Office, a highly compatible, free, and lightweight productivity suite.

1. Export List Data: In your SharePoint list, click 'Export' and select 'Export to Excel' or 'Export to CSV' to download your data locally.
2. Open with WPS Office: Launch WPS Spreadsheets and open the downloaded .xlsx or .csv file.
3. Analyze and Save: Use built-in pivot tables and filtering tools to manage your data offline, then save it securely to your local drive.

Fully compatible with Microsoft Excel (.xlsx and .csv) formats for seamless SharePoint list data management.Lightweight architecture ensures smooth performance even when handling massive datasets exported from SharePoint.Familiar spreadsheet interface that requires no learning curve to filter, sort, and analyze list data.Completely free to use with rich data visualization and offline archiving capabilities.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't users edit an item even after I give them direct Edit permissions?

If the SharePoint list's Advanced Settings are configured to 'Create items and edit items that were created by the user', this broad list-level setting strictly overrides individual item permissions for any user holding only Contribute or Edit access.

What permission level is required to override the 'edit own items' restriction?

A user must have Design, Full Control, or a custom permission level that includes the 'Override List Behaviors' right. This right allows them to bypass the item-level creation/edit restrictions set on the list.

Is there a limit to how many items can have broken inheritance in a SharePoint list?

Yes. While a SharePoint list supports up to 50,000 items with unique permissions, performance can begin to degrade significantly after 5,000 items. It is highly recommended to manage permissions at the folder or group level instead of the item level for large lists.

Document & File Issues