SV-253701r961044_rule
V-253701
SRG-APP-000177-DB-000069
MADB-10-004200
CAT II
10
Example command to create users with proper X509 certificate subject and issuer:
MariaDB>CREATE USER 'janedoe'@'%' IDENTIFIED BY 'Some_Password_Here_$9'
REQUIRE SUBJECT '/C=US/ST=Ohio/L=Columbus/O=MariaDB Corporation/CN=Jane Doe'
AND ISSUER '/C=US/ST=Ohio/L=Columbus/O=MariaDB Corporation/CN=MariaDB CA';
Query all users to confirm issuer and subject are configured correctly:
MariaDB>SELECT user, host, ssl_type, CAST(x509_issuer AS CHAR) AS issuer, CAST(x509_subject AS CHAR) AS subject FROM mysql.user;
If users are not mapped correctly, this is a finding.
V-253701
False
MADB-10-004200
Query all users to confirm issuer and subject are configured correctly:
MariaDB>SELECT user, host, ssl_type, CAST(x509_issuer AS CHAR) AS issuer, CAST(x509_subject AS CHAR) AS subject FROM mysql.user;
If users are not mapped correctly, this is a finding.
M
5475