title: How to Handle User Roles in SharePoint 2010
body: <p>I have been charged with architecting an enterprise level custom application in SharePoint 2010 and I'm trying to figure out a good authorization scheme for users.  The application must retrieve data from an existing LOB database and display bits and pieces of it granularly based on the user's role.  Would it be better to use SharePoint's user profiles and add some custom attributes to handle this granular security, or ditch SharePoint's profiles and go the SQL Server route to store users and roles?  Thanks.</p>