Skip to main content

CREATE USER

Use the CREATE USER command to create a new user account in RisingWave.

Syntax

CREATE USER user_name [ [ WITH ] system_permission [ ... ]['PASSWORD' { password | NULL }] ];

If you do not want password authentication for the user, omit the PASSWORD option.

System permissions

OptionDescription
SUPERUSERGrants the user superuser permission. A superuser can override all access restrictions. NOSUPERUSER is the default value.
NOSUPERUSERDenies the user superuser permission. A superuser can override all access restrictions. NOSUPERUSER is the default value.
CREATEDBGrants the user the permission to create databases. NOCREATEDB is the default value.
NOCREATEDBDenies the user the permission to create databases. NOCREATEDB is the default value.
CREATEUSERGrants the user the permission to create new users and/or alter and drop existing users. NOCREATEUSER is the default value.
NOCREATEUSERDenies the user the ability to create new users and/or alter and drop existing users. NOCREATEUSER is the default value.

Examples

The following statement creates a user account with the name "user1" and password 'pAssword12345'.

CREATE USER user1 
WITH PASSWORD 'pAssword12345';
tip

You can connect to RisingWave with the newly created user account.

To switch to the new user account:

Quit current connection.
\q
Connect and log in with the new account.
psql -h localhost -p 4566 -d dev -U user1

Enter the password to log in.

note

Names and unquoted identifiers are case-insensitive. Therefore, you must double-quote any of these fields for them to be case-sensitive.

Ask AI

Help us make this doc better!

Was this page helpful?

Happy React is loading...