问题描述
亲爱的
我们进行了内部审核，以验证应将哪些数据库许可/权限分配给SQL中的不同用户.请帮助我们确定SharePoint 2013服务器场安装的不同服务帐户所需的SQL Server权限:
We have an internal review to verify what DB permission/rights should be assigned to different users in SQL. Please help us determining the SQL server permissions/rights required for different service accounts for a SharePoint 2013 farm installation:
我已经通过Technet文章 ;，但是它没有提供有关SQL端所需权限的任何信息，假设意外地有人更新/删除了任何权限，那么我们如何才能分配所需的权限.任何描述权限的有用链接都将很有帮助.
I have gone through Technet Article but it does't give any information on rights required at SQL side, suppose accidentally anyone has updated/removed any rights then how can we assign back the required rights. Any useful links describing the permission would be helpful.
谢谢
Deepak Semwal
Deepak Semwal
在technet上回答您的问题.
Answer to your Question on technet.
推荐答案
SharePoint服务器场帐户:添加到以下SQL Server安全角色:
SharePoint farm account: add to the following SQL Server security roles:
dbcreator固定服务器角色；
dbcreator fixed server role;
securityadmin固定服务器角色；
securityadmin fixed server role;
db_owner服务器场中所有数据库的固定数据库角色；
db_owner fixed database role for all databases in the server farm;
SharePoint服务器场服务帐户:SQL Server和数据库权限包括:
SharePoint farm service account: SQL Server and database permissions include:
dbcreator固定服务器角色；
Dbcreator fixed server role;
Securityadmin固定服务器角色；
Securityadmin fixed server role;
db_owner(用于所有SharePoint数据库)；
db_owner for all SharePoint databases;
SharePoint服务器场配置的WSS_CONTENT_APPLICATION_POOLS角色的成员资格 数据库；
Membership in the WSS_CONTENT_APPLICATION_POOLS role for the SharePoint server farm configuration database;
SharePoint_Admin内容数据库的WSS_CONTENT_APPLICATION_POOLS角色的成员身份；
Membership in the WSS_CONTENT_APPLICATION_POOLS role for the SharePoint_Admin content database;
SharePoint搜索服务帐户:已分配给内容数据库的SP_DATA_ACCESS角色.
SharePoint Search service account: assigned to the SP_DATA_ACCESS role for the content databases.
sa帐户始终作为数据库引擎登录名存在，并且是sysadmin固定服务器角色的成员.
The sa account is always present as a Database Engine login and is a member of the sysadmin fixed server role.
更多信息请参阅下面的TechNet文章:
More information refer to the TechNet articles below:
https://technet.microsoft.com/en-us/library/cc263445.aspx
https://technet.microsoft.com/en-us/library/cc678863.aspx
最诚挚的问候，
Grace Wang
Grace Wang
这篇关于服务帐户的SharePoint 2013权限要求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！