​
Syntax for creating a new user

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

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

Below are the options for 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.

​
Syntax for creating a user with OAuth authentication

In addition, you can create a user with OAuth authentication. The syntax is as follows:

CREATE USER user_name WITH oauth (
  jwks_url = 'xxx.com',
  issuer = 'risingwave',
  other_params_should_match = 'xxx',
);

The jwks_url and issuer parameters are mandatory. On the other hand, other_params_should_match is an optional parameter that will be validated against jwt.claims. Please ensure that all keys in the options are in lowercase.

kid and alg are required in the header of JWT, and kid is also required in the JWKs returned by the JWKS server. All parameters set in user creation (except jwks_url) will be checked in the claims of JWT. Any mismatch will deny the login process.

​
Examples

​
Create a user account and switch to it

The following statement creates a user account with the name “user1” and password ‘pAssword12345’.

CREATE USER user1
    WITH PASSWORD 'pAssword12345';

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.

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

​
Create a user with OAuth authentication

Here is an example of creating a new user test with OAuth authentication.

Connect and log in with the root account.

psql -h localhost -p 4566 -d dev -U root

Create a new user test with OAuth authentication in psql.

CREATE USER test WITH oauth (
  jwks_url = 'xxx.com',  // required
  issuer = 'risingwave',  // required
  other_params_should_match = 'xxx',  // optional, will be checked against jwt.claims
);

Connect and log in with the new account.

-- The password here is actually OAuth token, and will be passed with plaintext.
psql -h localhost -p 4566 -d dev -U test

Was this page helpful?

CREATE TABLECREATE VIEW