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 database information. The Admin user is by default granted authority to perform this task. See more information about managing users and roles.
Creating a database
Follow the steps given below to create a database.
- Log in to the management console and select Databases under RSS Manager .
- Select environment and click the Add Database link and fill in the database information.
The newly-created database appears in the Databases screen. For example,
Database URL allows you to point to the database
Creating database snapshots:
A database snapshot is a read-only, static view of a database. You can create snapshots of a database at any given time by clicking Snapshot in the above screen. Note that this function is only available if the RSS environments in your system are configured as explained here.
Attaching database users
- Click the Manage link to attach a user and a privilege template to the newly-created database. For example,
Available Database User: This drop-down list is populated by the users created for the RDBMS. Also see Creating Database Users.Database Privileges Template: This drop-down list is populated by the privilege templates created in RSS. It sets the appropriate permission scheme for the database user selected above. Also see Creating Privilege Templates.
- After attached User to Database it will display like below.
The purpose of each of the links associated with the database user is described below.
This option opens the Database Console window, which displays the database tables and allows you to execute SQL queries on the data. For example,
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.
The Edit link allows you to change user privileges.
Detach link allows you to detach user from database.