Materialize/doc/user/content/releases/v0.63.md

---

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
  • mz_internal.mz_show_[my_]cluster_privileges
  • mz_internal.mz_show_[my_]database_privileges
  • mz_internal.mz_show_[my_]default_privileges
  • mz_internal.mz_show_[my_]object_privileges
  • mz_internal.mz_show_[my_]schema_privileges
  • mz_internal.mz_show_[my_]system_privileges

  Roles

  • mz_internal.mz_show_[my_]role_members

It's important to note that role-based access control (RBAC) is disabled by default. You must contact us to enable this feature in your Materialize region.

Bug fixes and other improvements

• Add the max_query_result_size configuration parameter, 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 and Hex.