Detections
Analytics
MADB-10-000200 - MariaDB must integrate with an organization-level authentication/access mechanism providing account management and automation for all users, groups, roles, and any other principals.
Warning! Audit Deprecated
This audit has been deprecated and will be removed in a future update.
View Next Audit VersionInformation
Enterprise environments make account management for applications and databases challenging and complex. A manual process for account management functions adds the risk of a potential oversight or other error. Managing accounts for the same person in multiple places is inefficient and prone to problems with consistency and synchronization.A comprehensive application account management process that includes automation helps to ensure that accounts designated as requiring attention are consistently and promptly addressed.
Examples include, but are not limited to, using automation to take action on multiple accounts designated as inactive, suspended, or terminated, or by disabling accounts located in noncentralized account stores, such as multiple servers. Account management functions can also include assignment of group or role membership; identifying account type; specifying user access authorizations (i.e., privileges); account removal, update, or termination; and administrative alerts. The use of automated mechanisms can include, for example: using email or text messaging to notify account managers when users are terminated or transferred; using the information system to monitor account usage; and using automated telephone notification to report atypical system account usage.
MariaDB must be configured to automatically utilize organization-level account management functions, and these functions must immediately enforce the organizations current account policy.
Automation may be comprised of differing technologies that when placed together contain an overall mechanism supporting an organizations automated account management requirements.
NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.
Solution
Integrate MariaDB security with an organization-level authentication/access mechanism providing account management for all users, groups, roles, and any other principals.As the database administrator, install and configure the PAM authentication module:
MariaDB> INSTALL SONAME 'auth_pam';
PAM supports many authentication methods including LDAP, Active Directory, and Kerberos. Each method must be configured properly in /etc/pam.d and /etc/pam.conf.
To alter non-PAM authenticated users to using PAM:
MariaDB> ALTER USER 'username'@'host' IDENTIFIED VIA pam USING mariadb_ldap;
See Also
https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_MariaDB_Enterprise_10-x_V2R3_STIG.zip
Item Details
Audit Name: DISA MariaDB Enterprise 10.x v2r3 DB
References: CAT|I, CCI|CCI-000015, Rule-ID|SV-253667r1043176_rule, STIG-ID|MADB-10-000200, Vuln-ID|V-253667
Plugin: MySQLDB
Control ID: 0d3b5ad4e037ccb4be59c7bb99ed7db600f60b248b7ab1794d9427db36391417