Creates a database user or group.
CREATE USER user-name IDENTIFIED BY password
The name of the user you are creating.
The password for the user you are creating.
If you use this statement in a procedure, do not specify the password as a string literal because the definition of the procedure is visible in the SYSPROCEDURE system view. For security purposes, specify the password using a variable that is declared outside of the procedure definition.
User IDs cannot:
Passwords are case-sensitive and they cannot:
The following example creates a user named SQLTester with the password welcome.
CREATE USER SQLTester IDENTIFIED BY welcome