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 | √ | √ | √ | √ | √ |
It give overall knowledge of Role and permissions related to Sitecore databases
LikeLike
Good informative article.
Thanks
LikeLike
Nice article. Really helpful.
LikeLike