Create a new user ID.
CREATE USER userID IDENTIFIED BY password
Example:
This statement adds user ID Joe to a database with password welcome:
CREATE USER Joe IDENTIFIED BY welcome