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
— command option:PASSWORD 'password'
— creates a user with the passwordpassword
.PASSWORD NULL
— creates a user with an empty password (default).NOLOGIN
- disallows user login (user lockout).LOGIN
- allows user login (default).
Note
The scope of the commands CREATE USER
, ALTER USER
, and DROP USER
does not extend to external user directories. Keep this in mind if users with third-party authentication (e.g., LDAP) are connecting to YDB. For example, the CREATE USER
command does not create a user in the LDAP directory. Learn more about YDB's interaction with the LDAP directory.