Creating Database Users

In order to add a database user, you must first create a database server instance. A database server instance acts as the container for the provisioned databases/database users.  By default, you have a database server cluster by the name of WSO2_RSS, which provides the storage provisioning infrastructure. However, individual tenants can also define their own. When databases are created, the 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 cluster.  

You can 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.

1. Log in to the management console and select Database Users under RSS Manager.
   
   
2. Select the environment and click Add Database User. Enter the new database user details as shown below. 
   
3. Click Save to complete.  You now have a database user, which you can connect to a database.
   
4. The created user can be connected to a database as explained here.