You can use the high-performance Advanced Auditing feature in Amazon Aurora to audit database activity. To do so
- Enabling it is dynamic and it doesn't perform a cluster restart
- You can download the audit logs from console or aws cli
- You must be using Aurora 1.10.1 or greater to use Advanced Auditing.