running a separate process to run reports

I am creating a bunch of temporary tables. If they already exist then I delete them. I am running on AWS RDS. So if user A creates his temp tables and is still using them and user B tries to create his own temp tables, but sees (on the RDS server) that they already exist, so deletes them (but they are user A's temp tables), this could be an issue. I need to be certain that user A's temp tables and user B's temp tables do no collide?

proof that an old dog can learn new tricks