CREATE USER

Creates a user with the specified name and password.

Syntax:

CREATE USER user_name [option]

• user_name: The name of the user. It may contain lowercase Latin letters and digits.

• option: The password of the user:

  • PASSWORD 'password' creates a user with the password password. The ENCRYPTED option is always enabled.
  • PASSWORD NULL creates a user with an empty password.