Users and Permissions

Only users with System Administrator privileges can add or delete users or modify their privileges. The initial admin user that is created when the OneDB Explore server starts for the first time has System Administrator privileges. Additional users with System Administrator privileges can be created.

To add a user, delete a user, or modify their OneDB Explore system privileges and permissions, a System Administrator user should click on their user icon in the top right corner of the title bar and go to the System Settings > User Management page.

When adding a user, you can optionally make the new user a System Administrator if you want them to manage users and configure OneDB Explore. System Administrators automatically have full access (Read, SQL, and Admin permissions) on all servers and groups. When creating a new non-System Administrator, you have the option to grant Read, SQL, and/or Admin permissions for that user to any servers and groups that have been added to OneDB Explore.

In order to run administrative actions on an OneDB database server, a user must have Admin permissions on that server and admin credentials must have been provided when adding that server to OneDB Explore. You can review and edit server credentials by going to the server’s Setup page or by going to the group dashboard, selecting the server's card, and clicking Edit.

Permissions for a server or a group in OneDB Explore are inherited. If a user is granted Read or Admin privilege on a group, the same privilege will be granted on all servers and sub-groups within that group.

While the System Settings > User Management page allows you to view and edit the complete permissions for each individual user of OneDB Explore, there is also a Permissions page specific to each server or group that allows to you to see (and edit) all users who have permissions to that particular server or group. You can access this page by navigating to a particular server or group and clicking on Permissions in the side-bar menu.