Materialize Logo

CREATE USER

New in v0.7.0.

CREATE USER creates a new role.

Syntax

CREATE USER user_name LOGIN NOLOGIN SUPERUSER NOSUPERUSER
Field Use
LOGIN Grants the user the ability to log in.
NOLOGIN Denies the user the ability to log in.
SUPERUSER Grants the user superuser permission, i.e., unrestricted access to the system.
NOSUPERUSER Denies the user superuser permission.
role_name A name for the role.

Details

CREATE USER is an alias for CREATE ROLE, except that the LOGIN option is implied if it is not explicitly specified.

Did this info help?
Yes No