Skip to main content
In RisingWave, a database user is similar to a database user or role in Postgres, allowing a person or application to access a specific database or set of databases within a cluster. Also, you connect and log in to a cluster as one of its database users. Database users can be assigned specific permissions to control their database privileges. Currently, all database users have the superuser privilege. Future releases will introduce more granular permissions.

​
Create a database user

Choose one of the following to create a database user.
  • You can create a database user when connecting to a cluster.
  • You can click Create user on the Users page of the cluster details view to create a new user.
  • You can run the CREATE USER command to create a new user after connecting to a cluster using the SQL Editor or terminal. Ensure that you have logged in to the cluster with a user that has the CREATEUSER privilege. A super user has all privileges, including CREATEUSER.

​
Change database user password

You can change the password of any database user in your cluster.
  1. Go to the RisingWave Cloud dashboard, and open the cluster that contains the user.
  2. In the cluster navigation, click Users.
  3. Click Change password of a user.
  4. Enter the new password and re-enter it to confirm. You do not need to enter the old password to continue.
  5. Click Save to apply the change.

​
Delete a database user

If you no longer need a database user, you can delete it.
  1. Go to the RisingWave Cloud dashboard, and open the cluster that contains the user.
  2. In the cluster navigation, click Users.
  3. Click of the user you want to delete.
  4. Enter the user name for confirmation. You don’t need to enter the password to continue.
  5. Click Delete.