Database Workspaces

As the complexity of your database grows, the number of tabs may start cluttering the screen. While you can hide some irrelevant tabs for certain roles, such as tabs representing various reference tables like lists of statuses, countries, cities, and so on, which regular users don’t directly access, as a database administrator, you may still need to have direct access to these tabs for maintenance purposes. This dilemma can be solved with Workspaces.

WorkSpaces all

Workspaces can be used to divide a large collection of tabs into several smaller sets that cover different aspects of database usage. You can easily switch between the current workspaces via a dropdown box located at the top-right corner of the page, and, of course, you still have access to all tables on a single screen if you want to.

WorkSpaces List

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

WorkSpace Inv

To create workspaces:

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

  2. Select the Database tab.

  3. Choose Database > Workspaces in the setup menu.

Creating Workspace

WorkSpace-Settings.gif

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

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

Workspaces Access

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

WorkSpace Access

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

WorkSpaces Role Access

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