V-271266
Microsoft SQL Server 2022 Instance Security Technical Implementation Guide
Title
SQL Server must enforce approved authorizations for logical access to information and system resources in accordance with applicable access control policies.
Description
<VulnDiscussion>Authentication with a DOD-approved PKI certificate does not necessarily imply authorization to access SQL Server. To mitigate the risk of unauthorized access to sensitive information by entities that have been issued certificates by DOD-approved PKIs, all DOD systems, including databases, must be properly configured to implement access control policies. Successful authentication must not automatically give an entity access to an asset or security boundary. Authorization proced...
Fix Text (Documentation Requirement)
Use GRANT, REVOKE, DENY, ALTER SERVER ROLE … ADD MEMBER … and/or ALTER SERVER ROLE …. DROP MEMBER statements to add and remove permissions on server-level securables, bringing them into line with the documented requirements.