The first part is easy: connect as a privileged user (such as SYS) and CREATE USER. However, that's most probably not enough as that user doesn't have any privileges (it can't even connect to the database) so you need to GRANT certain privileges. Here's an example: