SV-271286r1108474_rule
V-271286
SRG-APP-000133-DB-000198
SQLI-22-006700
CAT I
10
From a command prompt, open lusrmgr.msc. Navigate to "Users" and right-click "Individual User". Select "Properties", then "Member Of".
Configure SQL Server and OS settings and access controls to restrict user access to objects and data that the user is authorized to view/use.
From the system documentation, obtain the list of accounts authorized to install/update SQL Server. Run the following PowerShell command to list all users who have installed/modified SQL Server 2022 software and compare the list against those persons who are qualified and authorized to use the software.
sl "C:\Program files\Microsoft SQL Server\160\Setup Bootstrap\Log"
Get-ChildItem -Recurse | Select-String -Pattern "LogonUser = "
If any accounts are shown that are not authorized in the system documentation, this is a finding.
V-271286
False
SQLI-22-006700
From the system documentation, obtain the list of accounts authorized to install/update SQL Server. Run the following PowerShell command to list all users who have installed/modified SQL Server 2022 software and compare the list against those persons who are qualified and authorized to use the software.
sl "C:\Program files\Microsoft SQL Server\160\Setup Bootstrap\Log"
Get-ChildItem -Recurse | Select-String -Pattern "LogonUser = "
If any accounts are shown that are not authorized in the system documentation, this is a finding.
M
5677