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 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.
You can create an unlimited number of workspaces. Workspaces are ordered alphabetically in the dropdown menu.
To create workspaces:
-
Click the
Setup
link in the top right corner of the window. -
Select the
Database
tab. -
Choose
Database
>Workspaces
in the setup menu.
Creating Workspace
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.
If the uploaded image is in PNG format and does not exceed 300×100 pixels, it is used as is. Images that exceed these dimensions or are provided in a format other than JPEG or PNG are downscaled and converted to JPEG.
- 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.
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.