---
title: "Materialize v0.63"
date: 2023-08-02
released: true
patch: 4
---

## v0.63.0

#### SQL

* Improve and extend the base implementation of **Role-based
  access control** (RBAC):

  * Require `USAGE` privileges on the schemas of all connections, secrets, and types used in a query.

  * Add system catalog views that present privileges and role memberships using
    human-readable names instead of identifiers. Each view has two variants:
    one that presents all privileges or roles, and another that only presents
    privileges and roles that contain the current role.

    **Privileges**

    * [`mz_internal.mz_show_all_privileges`](/sql/system-catalog/mz_internal/#mz_show_all_privileges)
    * [`mz_internal.mz_show_[my_]cluster_privileges`](/sql/system-catalog/mz_internal/#mz_show_cluster_privileges)
    * [`mz_internal.mz_show_[my_]database_privileges`](/sql/system-catalog/mz_internal/#mz_show_database_privileges)
    * [`mz_internal.mz_show_[my_]default_privileges`](/sql/system-catalog/mz_internal/#mz_show_default_privileges)
    * [`mz_internal.mz_show_[my_]object_privileges`](/sql/system-catalog/mz_internal/#mz_show_object_privileges)
    * [`mz_internal.mz_show_[my_]schema_privileges`](/sql/system-catalog/mz_internal/#mz_show_schema_privileges)
    * [`mz_internal.mz_show_[my_]system_privileges`](/sql/system-catalog/mz_internal/#mz_show_system_privileges)

    **Roles**

    * [`mz_internal.mz_show_[my_]role_members`](/sql/system-catalog/mz_internal/#mz_show_role_members)

  It's important to note that role-based access control (RBAC) is **disabled by
  default**. You must [contact us](https://materialize.com/contact/) to enable
  this feature in your Materialize region.

#### Bug fixes and other improvements

* Add the `max_query_result_size` [configuration parameter](https://materialize.com/docs/sql/show/#other-configuration-parameters),
which allows limiting the size in bytes of a single query’s result.

* Support most single DDL statements in explicit transactions. This improves the
  integration experience with external tools like [Deepnote](https://deepnote.com/)
  and [Hex](https://hex.tech/).