SV-223270r612235_rule
V-223270
SRG-APP-000516
SP13-00-000175
CAT II
10
Configure the SharePoint setup account with minimum privileges on the SQL server.
Configure the account on the SQL server.
- Launch the SQL Server Management Console and navigate to Security >> Logins.
- Select the SharePoint Setup User account.
- Click on "Server Roles".
- Ensure only public, dbcreator, and securityadmin roles are checked.
- Remove checks from all other roles.
The SharePoint setup account must be configured with the minimum privileges on the SQL server.
- Launch the SQL Server Management Console and navigate to Security >> Logins.
- Select the SharePoint Setup User account.
- Click on "Server Roles" and verify only public, dbcreator, and securityadmin are checked.
- Click on "User Mapping" and verify that the setup account is a member of the public and db_owner role on each SharePoint database.
Otherwise, this is a finding.
V-223270
False
SP13-00-000175
The SharePoint setup account must be configured with the minimum privileges on the SQL server.
- Launch the SQL Server Management Console and navigate to Security >> Logins.
- Select the SharePoint Setup User account.
- Click on "Server Roles" and verify only public, dbcreator, and securityadmin are checked.
- Click on "User Mapping" and verify that the setup account is a member of the public and db_owner role on each SharePoint database.
Otherwise, this is a finding.
M
4096