WSS3/Sharepoint 2007 - Permissions to edit in Datasheet view
As mentioned in my previous post I've been doing some work with WSS3/Sharepoint 2007 recently in which we need to programmatically create custom permission levels for users of certain sites. Although I thought I'd correctly assigned the relevant permissions to the custom permission level our users have just reported an issue with the editing of lists in Datasheet view.
The custom permission level I've created assigns users add, delete, edit and view permissions on list items. Using the standard view of a list users can click the New menu option and add a new item to the list. So far, so good. However if they switch to Datasheet view and try to add a new item they receive an error stating that they do not have permission to add items to the list and the only option they can take is to discard their changes.
For reasons I won't even pretend to understand, the AddListItems permission on its own is not sufficient to allow a user to add to a list in Datasheet view. The user also need to have the BrowseUserInformation permission as well. Once this is added to our custom permission level users can now add, delete, edit and view list items correctly in Datasheet view.
- If you come across the same issue you can solve it using either of the following methods
- Add the BrowseUserInformation permission to your custom permission level
Ensure that all users are granted the Limited Access permission level (this include the BrowseUserInformation permission by default).
del.ico.us | 
Digg It | 
Technorati | 
StumbleUpon | 
Furl | 
reddit