CREATE USER

create_user_statement
	:	"create"! "user"! user_def (COMMA! user_def)* 
			{ ## = #(#[USER_CREATE, "USER_CREATE"],##); }

user_def
	:	user_identifier ("identified"! "by"! ("password"!)? character_string_literal )? (with_option)?

with_option
	:	"with"! "admin" "option"!

user_def

the name of created user and his initial password.

with_option

Defines is created user administrator of this server or not.

This command force 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.

• ERR_CONNECTION_OPERATION_NOT_PERMITTED - Valentina is running in local mode or query-issuer is not administrator of Valentina Server.

• ERR_CARDINALITY_VIOLATION - mismatching in user definitions mentioned in the query.

• ERR_CONNECTION_USER_ALREADY_EXISTS - user mentioned in the query is

already exist.

Example:

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