Database Workspaces

When database complexity grows, tabs may start cluttering the screen. Of course you can hide some irrelevant tabs for certain roles - such as tabs representing various reference tables: list of statuses, countries and cities and so on, regular users have no direct access to, yet, being a database administrator you may still need to have direct access to these tabs for maintenance purposes. This dilemma can be solved with Workspaces.


The Workspaces can be used to slice large collection of tabs into several smaller sets covering different aspects of database usage. The current workspace can be easily switched via dropdown box located at the top-right corner of the page, and, of course you still have the access to all tables on a single screen if you want to.


When the workspace is chosen, its name is displayed in the top right corner and tables included to this workspace are shown on the screen. Also a workspace logo can be displayed instead of the database logo.


To create the workspaces:

Click the Setup link in the top right corner of the window.

Select the Database tab.

Choose Database > Workspaces in the setup menu.

To create a new Workspace, click on the a New button and the system will open the following form:


Name Enter a name of the workspace.
Logo Specify an optional logo for the workspace. It will replace a database logo when the workspace is selected.
Access Restrict workspace access by role.
Tables Choose tables that should be included to this workspace and save changes.

When the workspaces are added, you can adjust the user access.

To restrict available workspaces by role, click on the Workspaces Access button. Also there is the ability to hide "All Tables" option from workspaces dropdown. In that case, system will automatically redirect end-users to the first available workspace.


Workspaces respect access rights defined for a table - if the table is inaccessible for a certain role, it is not displayed even if it is assigned to a workspace; workspaces containing no accessible tables are not listed in the dropdown.