Update documentation for workaround to database sharing idiosyncracies
@@ -14,6 +14,9 @@ There might be times when it might be helpful to setup multiple databases. For
To create a new database, select the System/Databases menu, click on the Add button in the databases table, and enter the name for a new database. The name should not contain any spaces or reserved characters. After a few moments, a new database will be created and your CAIRIS application will point to this database. Any databases you create will be visible only to your account.
+.. note::
+ Based on the configuration of MySQL, you may find that - on creating a new database - you no longer see the default database in your database list. If this is the case, you should logout of CAIRIS and log back in to return to the default database.
+
To open another database, select the System/Databases menu, and click on the table row corresponding with the name an existing database. After a few moments, your CAIRIS application will point to the chosen database.
You can delete a database by selecting the System/Databases menu, and clicking on the Delete button next to the database you want to remove. You cannot delete the database you currently have open.
@@ -24,3 +27,6 @@ Providing database access to other users
----------------------------------------
If you have a created a non *default* database, you can grant or revoke access to other users by clicking on the Permissions button. Adding other users to the permissions list grants access, and removing them revokes access.
+
+.. note::
+ Based on the configuration of MySQL, you may find the list of users with permission to access the database may not always show correctly once a permission has been added. If this is the case, and the user granted access to a database is unable to access it, you can manually grant or revoke permissions on the server using the dbctl.py script in cairis/cairis/bin, e.g. ``./dbctl.py --database MySharedDB --user shamal.faily@gmail.com --privilege grant`` .
