In sharepoint 2010 and sql server 2012 r2 which permissions need on sharepoint databases and sql server roles for below service accounts.
service accounts:
- Spfarm account
- spadmin account
- search service application account
- Web application Pool account
- Service application pool account
Databases:
- Configuration database
- Search Service application databases
- Content databases
- Service applications database(managed metadata)
SQL Server Roles above service accounts:
- is Spfarm account should be db_owner for all above databases?
- Search service should be db_owner for all search databases?
- Search service and spfarm account need any permissions on master and tempdb also?