Switch to: V9V8V7V6V5

CREATE USER

Syntax

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"!

Arguments

user_def

the name of created user and his initial password.

with_option

Defines is created user administrator of this server or not.

Description

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.

Errors

  • 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.

Examples

Example:

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