SV-255335r1051115_rule
V-255335
SRG-APP-000148-DB-000103
ASQL-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;
https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-user-transact-sql
Review Azure SQL Database users to determine whether shared accounts exist. (This does not include the case where Azure SQL Database 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 Database using a standard, shared account, ensure it also captures the individual user identification and passes it to Azure SQL Database.
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-255335
False
ASQL-00-007800
Review Azure SQL Database users to determine whether shared accounts exist. (This does not include the case where Azure SQL Database 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 Database using a standard, shared account, ensure it also captures the individual user identification and passes it to Azure SQL Database.
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
5500