User and passwords for postgresql-database-plugin

Vault has audit logs so you can see what happened there. For the database itself it depends on what you have setup there too for auditing.