Switch to: V9V8V7V6V5

CREATE USER

Syntax

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

Arguments

user_def

the name of the created user and his initial password.

with_option

Defines is created user administrator of this server or not.

Description

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.

Examples

Example:

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