If you're using Unity Catalog, you can query the information_schema.tables table in the catalog and you can find which tables were created by which user.

If you're not using UC, you can iterate over the tables, run a DESCRIBE HISTORY <table_name> command on the table and check the username at version 0. But I doubt that you would still have that version in your log because by default, the logs over 30 days are deleted.