MariaDB must map PKI ID to an associated user account.
An XCCDF Rule
Description
The DoD standard for authentication is DoD-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.
- ID
- SV-253701r961044_rule
- Version
- MADB-10-004200
- Severity
- Medium
- References
- Updated
Remediation Templates
A Manual Procedure
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';