SV-235149r638812_rule
V-235149
SRG-APP-000180-DB-000115
MYS8-00-006300
CAT II
10
Configure MySQL Database Server 8.0 settings to uniquely identify and authenticate all non-organizational users who log on to the system.
Ensure all logins are uniquely identifiable and authenticate all non-organizational users who log on to the system. This likely would be done by ensuring mapping of MySQL accounts to individual accounts. Verify server documentation to ensure accounts are documented and unique.
Review MySQL Database Server 8.0 settings to determine if users uniquely identify and authenticate all non-organizational users who log on to the system.
select host, user FROM mysql.user WHERE user not in ('mysql.infoschema', 'mysql.session', 'mysql.sys');
If accounts are determined to be shared, determine if individuals are first individually authenticated.
If the documentation indicates that this is a public-facing, read-only (from the point of view of public users) database that does not require individual authentication, this is not a finding.
If non-organizational users are not uniquely identified and authenticated, this is a finding.
V-235149
False
MYS8-00-006300
Review MySQL Database Server 8.0 settings to determine if users uniquely identify and authenticate all non-organizational users who log on to the system.
select host, user FROM mysql.user WHERE user not in ('mysql.infoschema', 'mysql.session', 'mysql.sys');
If accounts are determined to be shared, determine if individuals are first individually authenticated.
If the documentation indicates that this is a public-facing, read-only (from the point of view of public users) database that does not require individual authentication, this is not a finding.
If non-organizational users are not uniquely identified and authenticated, this is a finding.
M
5277