Check: SQL4-00-020500
MS SQL Server 2014 Instance STIG:
SQL4-00-020500
(in versions v2 r3 through v1 r4)
Title
SQL Server must be configured to separate user functionality (including user interface services) from database management functionality. (Cat II impact)
Discussion
Information system management functionality includes functions necessary to administer databases, network components, workstations, or servers and typically requires privileged user access. The separation of user functionality from information system management functionality is either physical or logical and is accomplished by using different computers, different central processing units, different instances of the operating system, different network addresses, combinations of these methods, or other methods, as appropriate. An example of this type of separation is observed in web administrative interfaces that use separate authentication methods for users of any other information system resources. This may include isolating the administrative interface on a different domain and with additional access controls. If administrative functionality or information regarding DBMS management is presented on an interface available for users, information on DBMS settings may be inadvertently made available to the user.
Check Content
Check SQL Server permission settings to verify that administrative functionality is kept separate from user functionality. The views and functions provided in the supplemental file Permissions.sql can help with this review. If administrator and general user functionality are not separated either physically or logically, this is a finding.
Fix Text
Establish one or more locally-defined server roles and one or more locally-defined database roles for organizing administrative permissions. Grant administrative permissions to these roles. Assign the appropriate administrative users to these roles. Do not grant the roles and permissions to general users.
Additional Identifiers
Rule ID: SV-213854r397711_rule
Vulnerability ID: V-213854
Group Title: SRG-APP-000211-DB-000122
Expert Comments
CCIs
Number | Definition |
---|---|
CCI-001082 |
The information system separates user functionality (including user interface services) from information system management functionality. |
Controls
Number | Title |
---|---|
SC-2 |
Application Partitioning |