SV-276247r1150045_rule
V-276247
SRG-APP-000148-DB-000103
MSQL-00-007800
CAT II
10
Remove user-accessible shared accounts and use individual user IDs.
If necessary, use the DROP USER command to remove user-accessible shared accounts. Example provided below.
DROP USER [SharedAccount];
Review Azure SQL Managed Instance users to determine whether shared accounts exist. (This does not include the case where Azure SQL Managed Instance has a guest or public account that is providing access to publicly available information.)
If accounts are determined to be shared, determine if individuals are first individually authenticated. Where an application connects to Azure SQL Managed Instance using a standard, shared account, ensure it also captures the individual user identification and passes it to Azure SQL Managed Instance.
If individuals are not individually authenticated before using the shared account (e.g., by the operating system or possibly by an application making calls to the database), this is a finding.
If accounts are determined to be shared, determine if they are directly accessible to end users. If so, this is a finding.
V-276247
False
MSQL-00-007800
Review Azure SQL Managed Instance users to determine whether shared accounts exist. (This does not include the case where Azure SQL Managed Instance has a guest or public account that is providing access to publicly available information.)
If accounts are determined to be shared, determine if individuals are first individually authenticated. Where an application connects to Azure SQL Managed Instance using a standard, shared account, ensure it also captures the individual user identification and passes it to Azure SQL Managed Instance.
If individuals are not individually authenticated before using the shared account (e.g., by the operating system or possibly by an application making calls to the database), this is a finding.
If accounts are determined to be shared, determine if they are directly accessible to end users. If so, this is a finding.
M
5711