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 as explained in Configuring Environments for RDBMS. Alternatively, you can create the database server instances using the management console as explained in Creating RSS Instances.
Note that as a user, you need to be assigned to a role with the relevant authority in order to create or edit new database users from the management console. The Admin user is by default granted authority to perform this task. See more information about managing users and roles.
After a database server 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 and click Add Database User. Enter the new database user details as shown below.
- Click Save to complete. You now have a database user, which you can connect to a database.
- The created user can be connected to a database as explained here.