Had a friend ask about SQL database Role Memberships that are needed for SharePoint Server on-premise. Examined SQL roles on my dev farm. Reference table below.
Cheers!
Get-SPServiceApplication | Get-SPDatabase | Select TypeName | SQL Permission Role | |
App Management | App Management Database | SP_DataAccess | |
N/A | Configuration Database | dbo, WSS_Content_Application_Pools | |
N/A | Content Database | SP_DataAccess | |
Microsoft SharePoint Foundation | Microsoft SharePoint Foundation Subscription Settings Database | SubscriptionSettingsService_Application_Pool | |
Secure Store | Microsoft.Office.SecureStoreService.Server.SecureStoreServiceDatabase | SP_DataAccess | |
User Profile | Microsoft.Office.Server.Administration.ProfileDatabase | SP_DataAccess | |
User Profile | Microsoft.Office.Server.Administration.SocialDatabase | SP_DataAccess | |
State Service | Microsoft.Office.Server.Administration.StateDatabase | WSS_Content_Application_Pools | |
User Profile | Microsoft.Office.Server.Administration.SynchronizationDatabase | db_owner | |
Search Service Application | Microsoft.Office.Server.Search.Administration.SearchAdminDatabase | SPSearchDBAdmin | |
Search Service Application | Microsoft.Office.Server.Search.Administration.SearchAnalyticsReportingDatabase | SPSearchDBAdmin | |
Search Service Application | Microsoft.Office.Server.Search.Administration.SearchGathererDatabase | SPSearchDBAdmin | |
Search Service Application | Microsoft.Office.Server.Search.Administration.SearchLinksDatabase | SPSearchDBAdmin | |
Machine Translation Service | Microsoft.Office.TranslationServices.QueueDatabase | SP_DataAccess | |
Word Automation Services | Microsoft.Office.Word.Server.Service.QueueDatabase | SP_DataAccess | |
PerformancePoint | Microsoft.PerformancePoint.Scorecards.BIMonitoringServiceDatabase | SP_DataAccess | |
Business Data Connectivity | Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase | SP_DataAccess | |
Managed Metadata | Microsoft.SharePoint.Taxonomy.MetadataWebServiceDatabase | db_owner |
