I noticed the attack patterns in the application logs and I also found out an api_key was created alongside a new user - which was deactivated after the upgrade.
In order to assess the damage, is there any way to figure out what data was accessed using the api key?
you should check query and query_execution tables, those will give you the queries that the attacker run (you need to see which user id the attacker impersonated and then which user id the api key got
Checked query_execution table for any access using auth_method api_key or execution_id impersonating the hacked user id.
Thankfully I don’t see any entries.
I wonder why the attacker may have just left it there and not go ahead? Perhaps no personal benefit? Anyway, I was glad that there was no access to the data itself.