> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bytebase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bytebase 3.1.0 - Nov 21, 2024

> Google/GitHub SSO available in Pro Plan

## 🚀 New Features

* Support PostgreSQL role selection in DDL/DML issues.
* Add PostgreSQL database tenant mode option in project setting.
* Display package metadata for ORACLE on database page and SQL Editor.
* Support setting colors for environments for better visual distinction.
* Allow workspace admin to disable data export functionality.
* Add new SQL Review Rules for MySQL:
  * Prohibit DDL on specific tables for MySQL.
  * Prohibit DML on specific tables for MySQL.

## 🔔 Notable Changes

* Redefine SQL Editor related permissions:

  * Permissions
    * `bb.databases.query` -> `bb.sql.select`
    * `bb.databases.queryDML` -> `bb.sql.dml`
    * `bb.databases.queryDDL` -> `bb.sql.ddl`
    * `bb.databases.queryExplain` -> `bb.sql.explain`
    * `bb.databases.queryInfo` -> `bb.sql.info`
    * `bb.databases.export` -> `bb.sql.export`
    * `bb.instances.adminExecute` -> `bb.sql.admin`
  * Roles
    * `roles/projectQuerier` -> `roles/sqlEditorUser`

* API change:
  * Remove the `database` field of `sheet` in `SheetService`.
  * Disallow adding service account to a group via API (previously restricted in the UI) .
  * Deprecate `SQLService.Execute` method.

* Default PostgreSQL role to run a DDL/DML issue:
  * Instance connection user (previously database owner)
  * If PostgreSQL database tenant mode is on for a project, the role remains database owner.
  * For existing projects: PostgreSQL tenant mode will be automatically enabled if multitenancy is enabled for any database group.

## 🎄 Enhancements

* Expand audit log coverage to include more event types.
* Upgrade 1-click rollback user experience for MySQL.
* Upgrade parser to be compatible with PostgreSQL 15 syntax.
* Add compatibility with Elasticsearch 7.x.
* Support `DECLARE` and `SET` for SQL Server in SQL Editor.

## 💰 Pricing Adjustments

* Move SSO OAuth2 Google and GitHub from **Enterprise** to **Pro Plan**.
* Move self-service signup restriction from **Enterprise** to **Pro Plan**.

## ⚙️ Install and Upgrade

* [Fresh install](/get-started/self-host/deploy-with-docker)

* [Upgrade](/get-started/self-host/upgrade)

*Before upgrading: 1) Back up the [metadata](https://www.bytebase.com/docs/administration/back-up-restore-metadata/) — in-place downgrade is not supported. 2) Do not run multiple containers on the same data directory. 3) Terraform users: upgrade Bytebase server first, then apply the new Terraform config.*