Skip to content

The MySQL Database Server 8.0 must generate audit records when unsuccessful attempts to delete privileges/permissions occur.

An XCCDF Rule

Description

Failed attempts to change the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail, unauthorized attempts to elevate or restrict individuals and groups privileges could go undetected. In a SQL environment, deleting permissions is typically done via the REVOKE or DENY command. To aid in diagnosis, it is necessary to keep track of failed attempts in addition to the successful ones.

ID
SV-235120r961812_rule
Version
MYS8-00-003300
Severity
Medium
References
Updated

Remediation Templates

A Manual Procedure

Configure the MySQL Database Server to audit when unsuccessful attempts to delete privileges/permissions occur.

See the supplemental file "MySQL80Audit.sql".