Avatar of intoxicated_curveball
intoxicated_curveball
 asked on

Restrict access to SharePoint list

I only want a certain user group to have access to 'view' a particular subset of columns in a list. What is a the best way to do this?
Microsoft SharePoint

Avatar of undefined
Last Comment
intoxicated_curveball

8/22/2022 - Mon
Walter Curtis

It is not possible to have unique permissions on a SharePoint list view. As an option, but not tight security, you can create a page and add the list web part focused to the view you want to use, the page can have unique security. Again, the list view can not be locked down.

Another option, limit the access to the entire list. Or create a second list that is locked down and use a workflow to populate the list.

Hope that helps...
Marie Magadia

Option is to create 2 different views.
Sample:
View1 = Column1 | Column2 | Column3 (URL: http://sharepoint/sites/sitename/listname/Forms/View1.aspx)
View2 = Column1 | Column3 (URL: http://sharepoint/sites/sitename/listname/Forms/View2.aspx)

Then create a link on the navigation to the view identifying the groups.
Screenshot

SharePoint-Navigation.png
Hope it helps!
Walter Curtis

Be careful - the above shown solution does not consider the security part of the original question. Although correct, it is not going to address the security aspect of the question. Audiences are not a security construct.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
intoxicated_curveball

ASKER
Walter & Marie - Maybe I'm missing something here but when you create a view, it is only in the "list view" that you see this. When you click to view the record you will see ALL fields regardless of the view. Am I wrong? I need a solution that doesn't show all the fields when you "view" the individual record either.
Walter Curtis

View can be modified to show the fields you want to show, and hide the others.
intoxicated_curveball

ASKER
In SharePoint there are 3 ways to view a record:

In Edit mode
In List View mode
In Display mode (of individual record)

Modifying the view only affects the "List View", not the Edit or Display modes.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Walter Curtis

That's correct, somewhat.

For each item, an edit and display page are used. For a new item, a page is also used. A list view is a different page and shows multiple items. You can have various views of all list items.
Walter Curtis

Please don't abandon this question.
intoxicated_curveball

ASKER
Marie Magadia When I edit links I don't have the option to change the audience?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Walter Curtis

Honestly, the audience comment doesn't apply in this case.
intoxicated_curveball

ASKER
I've learned that the "Audience" option is not available because we're using the free version of SharePoint 2013. The same goes for new pages, you can't set the audience, unfortunately.

Any other ideas?
Walter Curtis

The answer is already in this thread. The first entry after your question.

As mentioned, Audiences have nothing to do with this situation, as you have just learned. Seems like you have a lot to learn about SharePoint.

Good luck, you will need it...
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
intoxicated_curveball

ASKER
I already explained why your proposed solution wasn't effective (here).

Making an ineffective solution doesn't entitle you to make derogatory comments. If your comments are not directly aimed at providing a solution or working towards one then you shouldn't make any at all.

And yes, I agree I have much to learn about SP... that's why I'm here asking questions.
Walter Curtis

Agreed. Now time to learn, time to teach.

Your comment:

In SharePoint there are 3 ways to view a record:

In Edit mode
In List View mode
In Display mode (of individual record)

Modifying the view only affects the "List View", not the Edit or Display modes.


Is correct, however don't confuse the forms (or modes as you refer to them). Forms are for a single item (record) of the list/library. Each item has 2 associated forms, a display form and an edit form. (These are sometimes called pages.) Note: a list/library has one other default form named "NewItem", that is used when a new item is added to the list/library.

The list view is not a form, but a page with a list view web part on it. When a list is created, SharePoint creates that page automatically. (You can also create a page manually and add a list view web part to it.) Also, the default view is created automatically when the list/library is created. Additional views can be created manually, and the columns to display as well as other properties such as sort order and # of items to show on a page can be set per view.

The question:

I only want a certain user group to have access to 'view' a particular subset of columns in a list. What is a the best way to do this?

implies that you want to work with the list/library views. As mentioned, views cannot be have access control. (There is a good work around provided above though.)

If the questions is to mean, that the forms View (display), Edit and even NewItem are to have varying columns based on the access granted to users, that is something that may be possible, but is not out of the box. You can of course control what columns are shown on the forms that everyone will see, but to control based on access would require customizations.

Hope that helps to explains somewhat deeper the various forms and views with a list and library. Let me know what other questions you may have and I will help if I can.

Have a good one...
ASKER CERTIFIED SOLUTION
intoxicated_curveball

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Walter Curtis

Glad you found a solution.

...
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
intoxicated_curveball

ASKER
No other effective solution provided for SharePoint Foundation 2013.