SQL Guide : Using SQL for database administration : Managing user privileges and roles : Creating users
  
Creating users
CREATE USER username IDENTIFIED BY password;
Only an administrator has the privilege to execute this statement. The following example creates a new user named CALVIN with the password HOBBES.
CREATE USER CALVIN IDENTIFIED BY HOBBES;
See also
Managing user privileges and roles