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 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.
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.
To create workspaces:
Setuplink in the top right corner of the window.
Workspacesin the setup menu.
To create a new workspace, click the
New button, and the system will open the following form:
- Enter the name of the workspace.
- Specify an optional logo for the workspace. It will replace the database logo when the workspace is selected.
- Restrict workspace access by role.
- Choose tables that should be included in this workspace and save changes.
Once the workspaces are added, you can adjust user 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 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.