You can execute the CREATE USER statement to create a user and set the password for the user.

Syntax

create_user_statement ::=  CREATE USER user_name identified by '''password''';
password ::= string

Parameters

Parameter Description
user_name The name of the user.
password The logon password for the user.

Examples

The following sample code provides an example on how to create a user and set the password for the user. 

create user test_user identified by 'testuserpassword';