Administration

The administration interface lets a team run DbGate as a shared, multi-user web application: you manage connections centrally, define who can sign in and how, and grant fine-grained access to databases and objects through users, roles and permissions. It also hosts shared team files. Everything configured here is stored in the storage database rather than in local files.

The administration tool is available only on the Team Premium edition. In the Community edition, please configure DbGate using environment variables instead.

All configuration from administration is saved into the storage database - use the STORAGE_xxx environment variables to configure it.

In this section:

• Authentication - configure sign-in methods and identity providers
• Connections - manage the connections available to your team
• Team Files - share SQL scripts, ER diagrams and charts
• Users - manage user accounts
• Roles - group permissions into roles
• Permissions - grant access to connections, databases and tables

Administrator access

Administration page is available on URL https://your_dbgate_instance/admin.html .

Root administrator should have password defined. You could set environment variable ADMIN_PASSWORD. If this variable is not defined, DbGate asks for admin password at first.

You could then add administration permission to different user with different authentication method, but at first, you have to open this admin page.