What licenses do I need?
A "normal" one, means you have to create a Azure SQL Database, as any other one.
What resources need to be created?
See answer before.
What permissions need to be assigned?
Depends on what the user should be able to do in the database.