Skip to main content

Posts

Showing posts from April, 2017

Add multiple database users with different privileges for the same database

Currently, the WSO2 Integration Cloud supports adding multiple database users for a same database, but does not support changing user privileges. Let's say someone has a requirement of using same database via two different user, one user has full access, where other user should have READ_ONLY access. How we do this in Integration Cloud? We are planning to add this as feature to change the user permissions, but until that you can do it as I have mentioned below. Steps: 1. Login Create a database with a user 2. Once you create a database you can see it as below, and you can add another user when clicking on the All users icon 3. There you can create new user or you can attach existing user to the same database I added two users  u_mb_2NNq0tjT and  test_2NNq0tjT to the database wso2mb_esbtenant1 My requirement is to give full access to the  u_mb_2NNq0tjT  user and remove INSERT permission from  test_2NNq0tjT  user. 4. Login to the mysql.storage.cloud.wso2.c