Before adding a database user, you must create a database server instance. A database server instance acts as a data store for the applications running under a tenant domainthe container for the provisioned databases/database users. By default, you have a database server instance cluster by the name WSO2_RSS providing the storage provisioning infrastructure but individual tenants can also define their own. RSS uses Relational Storage Service of WSO2 Storage Server uses a round robin algorithm to select the next database server instance from the list pertaining to the WSO2_RSS database server instance cluster, when creating databases.
To create a database server instance using the management console UI, see Database Server Instance. You can also create server instances directly in <PRODUCT_HOME>/repository/conf/etc/rss-config.xml file. For instructions, see Changing the Default RSS Configuration.
After a database service instance is created, follow the steps below to create a database user.
- Log in to the management console and select Database Users under RSS Manager.
- Select the environment.This is the environment that the database server instance is created on. and click Add Database User.
- Enter the new database user details. For example,
- Click Save to complete.
- You now have a database user using which you can manipulate data in your tenant domain.
- The purpose of each of the links associated with the database user is described below.
Explore database
This option opens the Database Console window, which displays the database tables and allows you to execute SQL queries on the data. For example,
Create datasources
Datasource is the connection set up to a database from the server. A datasource is a resource for the user, who can use it to expose data as services across different cluster nodes of his/her tenant space.
Edit/Drop
The Edit link allows you to change the user's password or privileges, and the Drop link allows you to delete the user.