CREATE USER

create_user_statement
    :    CREATE USER user_def (COMMA user_def)* 

user_def
    :    user_identifier [IDENTIFIED BY [PASSWORD] character_string_literal] [with_option]

with_option
    :    WITH ADMIN OPTION

user_def

the name of the created user and his initial password.

with_option

Defines is created user administrator of this server or not.

This command forces Valentina Server to add new users with names, passwords and admin options defined in the statement. This command is available for ADMINISTRATOR of vserver only.

Example:

CREATE USER User1 IDENTIFIED BY 'password' WITH ADMIN OPTION;