Use the CREATE USER
command to create a new user account in RisingWave.
Option | Description |
---|---|
SUPERUSER | Grants the user superuser permission. A superuser can override all access restrictions. NOSUPERUSER is the default value. |
NOSUPERUSER | Denies the user superuser permission. A superuser can override all access restrictions. NOSUPERUSER is the default value. |
CREATEDB | Grants the user the permission to create databases. NOCREATEDB is the default value. |
NOCREATEDB | Denies the user the permission to create databases. NOCREATEDB is the default value. |
CREATEUSER | Grants the user the permission to create new users and/or alter and drop existing users. NOCREATEUSER is the default value. |
NOCREATEUSER | Denies the user the ability to create new users and/or alter and drop existing users. NOCREATEUSER is the default value. |
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.test
with OAuth authentication.
Connect and log in with the root account.