Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

Next Webcast - Simple SQL Server Reporting - Click Here to Register
 

Permissions for SharePoint 'People or Group' Field Types


By:   |   Read Comments   |   Related Tips: > Sharepoint

Problem

Even with complete read and write access to a SharePoint list or library with a 'People or Group' field type, the user gets the message "The control is not available because you do not have the correct permissions". This puzzled me for a few minutes, but soon I had the solution...

time off request
Solution

I remembered that the People or Group field was using a SharePoint Group to limit the choices and display a pick list for the user.

hr approvers

When I checked the HR Approvers group setup...

(Click "Settings", then "Group Settings.)

...I noticed that only Group Members "can view the membership of the group".

group members

This is the option chosen by default when creating new groups. In most cases, this is certainly a fine choice. But in this case, when the group is being used as a lookup for a SharePoint field, some thought needs to occur in setting this up correctly.

After changing this to "Everyone"...

everyone

...the user was able to use the field normally.

new item

When using a SharePoint group as a source to the People and Groups field type in SharePoint, check to make sure all users that might be using the list or library have access to the specified SharePoint group.

Next Steps


Last Update:


next webcast button


next tip button



About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools