Creation should include the following syntax:
CREATE USER username IDENTIFIED BY password;