Creating Database Users

Before adding a database user, you must 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 instance cluster by the name WSO2_RSS providing the storage provisioning infrastructure but individual tenants can also define their own. 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.

1. Log in to the management console and select Database Users under RSS Manager.
   
   
2. Select the environment and click Add Database User.
3. Enter the new database user details. For example,
    
4. Click Save to complete.
   
5. You now have a database user using which you can manipulate data in your tenant domain.
   
   
6. 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.