Setting Sitecore Database Permissions

In one of my projects, client decided to change the infrastructure. During this process I got some new things to learn. Here in this article I am going to share the experience about Sitecore Database permissions.

While moving your databases from one server to another you need to check for the permissions provided to those databases so that it has enough access to work. Below is the list of Databases and minimal permissions to work –

 

Roles/Permissions	Core	Master	Web	Sessions	Analytics
db_datareader	√	√	√	√	√
db_datawriter	√	√	√	√	√
public	√	√	√	√	√
aspnet_Membership_BasicAccess	√
aspnet_Membership_FullAccess	√
aspnet_Membership_ReportingAccess	√
aspnet_Profile_BasicAccess	√
aspnet_Profile_FullAccess	√
aspnet_Profile_ReportingAccess	√
Execute	√	√	√	√	√