← Back to MariaDB Enterprise Server Security Technical Implementation Guide

V-286195

CAT II (Medium)

MariaDB must map a PKI ID to an associated user account.

Rule ID

SV-286195r1292144_rule

STIG

MariaDB Enterprise Server Security Technical Implementation Guide

Version

V1R1

CCIs

CCI-000187

Discussion

The DoW standard for authentication is DoW-approved PKI certificates. Once a PKI is validated, it is mapped to the DBMS user account for the authentication identity and then can be used for authorization decisions.

Check Content

Query all users to confirm the 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.

Fix Text

Sample 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';