Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


February 27, 2006

SharePoint Solutions

Get past the gaps in item-level security
RSS
View this exclusive article with VIP access -- click here to join |
See More Exchange Server and Outlook Articles Here | Reprints | Or sign up for our VIP Monthly Pass!

Microsoft SharePoint Portal Server 2003 and Windows SharePoint Services 2.0 continue to grow in popularity, and many Exchange Server admins are finding themselves in charge of designing, implementing, deploying, and managing a system based on one or both SharePoint products. Microsoft and others have done a great job of touting the strengths of SharePoint Portal Server and Windows SharePoint Services. Our goal is to inform you of these products' weaknesses—such as lack of item-level security—and give you potential solutions. Be aware that in this article, the term SharePoint refers to both SharePoint Portal Server 2003 and Windows SharePoint Services 2.0.

What's the Problem?
SharePoint security is a mix of varied capabilities at both the portal level (through SharePoint Portal Server) and the site level (through Windows SharePoint Services). What SharePoint doesn't include is the ability to set specific permissions on an individual piece of content. You can find mention in the product documentation and UI of item-level security that applies to a SharePoint Portal Server list, but the feature is primitive: Basically, a user who has Administrator permission to the list can use the feature to control which list items other users can read and edit. (Figure 1 shows the Item-level Permissions section of a list item's Properties screen.) SharePoint doesn't provide the capability to control the permissions assigned to a single list item or piece of content. Before considering the item-level security gap and possible solutions, it's important to understand the overall SharePoint security architecture and how SharePoint Portal Server security differs from Windows SharePoint Services security.

Roles. SharePoint includes a security object called a site group, or role. A role contains a set of permissions that together impart a general capability that serves a function in SharePoint. Although you can use the UI to see SharePoint roles, a more direct way to list all the default SharePoint roles is to use the stsadm.exe administration tool. For example, to enumerate all roles defined on a portal named portal01, type

stsadm   -o   enumroles   -url 
  http://portal01 

As the output in Figure 2 shows, two default SharePoint roles are Contributor and Web Designer. A Contributor can add content to document libraries and lists; a Web Designer has permission to modify the look and feel of a Share-Point Portal Server area or a Windows SharePoint Services site. You can't customize the permissions assigned to the Guest and Administrator default roles or delete these roles. You can modify the permissions assigned to other default roles, but we recommend that you create new roles and modify them as necessary. Doing so will preserve the default rights assigned to the out-of-the box roles, which you can use as templates for defining new roles.

To make a role functional, you assign user accounts or groups to the role. Wherever a role is assigned in the SharePoint hierarchy, the user is granted permission to perform the tasks associated with that role. If your SharePoint implementation isn't part of an Active Directory (AD) domain, the user and group accounts must be defined on the computer that runs SharePoint. If your SharePoint server or SharePoint Web farm is part of a domain, you can associate either local user and group accounts or AD user and group accounts to roles. Although you can assign SharePoint permissions directly to groups or to users, Microsoft recommends that you assign groups to roles and add users to those groups.

Applying security. Now that you understand the relationship between roles, users, and groups, let's consider how you can apply security in SharePoint. Table 1 lists and describes each SharePoint element (aka security surface) to which you can apply security. (For complete descriptions of these elements, refer to the "Windows Share-Point Services Administrator's Guide" at http://tinyurl.com/3hnup. You can navigate to the SharePoint Portal Server Administrator's Guide from the All Programs, SharePoint Portal Server program group.) On each security surface, you can assign a group or a user account to a role. To simplify the rest of the discussion, we'll refer to groups and user accounts in this context as security principals.

When you assign a security principal a role on a SharePoint security surface that has child elements, the child inherits the permission settings of its parent. For example, a SharePoint Portal Server subarea inherits the permission settings of its parent area. In Windows SharePoint Services, a subsite, workspace, or list inherits the permission settings of its parent. This inheritance continues through the hierarchy, unless you block it by explicitly assigning security principals to a security surface.

Now here's the strange part: You assign roles to security principals at the very top of the SharePoint Portal Server hierarchy, and those role assignments then flow down to any portal subarea for which inheritance is allowed and not blocked by explicit permissions assigned to a subarea's parent. In Windows SharePoint Services, you create roles in a site collection from the Top-Level Site Administration-Manage Site Groups screen. After you create the roles, they can be inherited down the site-collection hierarchy. But in Windows SharePoint Services, you also can assign roles explicitly to security principals at any place in the hierarchy. SharePoint Portal Server allows only for role inheritance.

This role-configuration inconsistency between SharePoint Portal Server and Windows SharePoint Services doesn't represent a gap in itself, but the result is that if you need to add a role in SharePoint Portal Server and you want to use that role somewhere in the SharePoint Portal Server hierarchy, you have to enable inheritance on the subarea to allow the role to appear in that area. You can explicitly assign a security principal in a SharePoint Portal Server area by assigning a set of permissions, which might be a convenient method but which is more difficult to manage than inheritance because it leads to a more-complex security configuration.

The primary differences in security architecture between SharePoint Portal Server and Windows SharePoint Services have to do with where and how you apply security. Whereas SharePoint provides explicit application of role, group, and user-based security for SharePoint Portal Server areas, Windows SharePoint Services sites, or Windows SharePoint Services lists, neither product extends the same security capability at the item level.

   Previous  [1]  2  Next 


Top Viewed ArticlesView all articles
No Jobs, No Excitement at Apple's Last Macworld Keynote

Apple CEO Steve Jobs made the right move in skipping out on his company's last appearance at Macworld: In a Tuesday keynote address at the conference, Apple had no interesting new products to sell, opting instead to spend mind-numbing amounts of time on ...

Where is Microsoft NetMeeting in Windows XP?

...

Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...


Exchange Server and Outlook Whitepapers Protecting (You and) Your Data with Exchange Server 2007

StoreVault SnapManagers for Microsoft Exchange and SQL Server

Related Events Storage Consolidation for Your Microsoft Applications: Reducing Cost and Complexity

Top 10 Email Security Challenges and Solutions

Mastering Exchange 2007 Server Management – May 29, 2008 (11:00 AM EST)

Check out our list of Free Email Newsletters!

Exchange Server and Outlook eBooks Spam Fighting and Email Security for the 21st Century

Understanding and Leveraging Code Signing Technologies

The Expert's Guide for Exchange 2003: Preparing for, Moving to, and Supporting Exchange Server 2003

Related Exchange Server and Outlook Resources Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.

Exchange & Outlook UPDATE eNewsletter
News, strategies, products, and developments in Exchange Server and Outlook messaging.

Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2009 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing