Audit MariaDB Which User Account Privileges Are Being Used
The audit plugin, when enabled, will provide the access information associated with users accounts.

There are also authentication plugins to centrally manage authentication.