ContextQMD
Back to Materialize

ALTER CLUSTER REPLICA

doc/user/content/sql/alter-cluster-replica.md

1231.0 KB
Original Source

Use ALTER CLUSTER REPLICA to:

  • Rename a cluster replica.
  • Change owner of a cluster replica.

Syntax

{{< tabs >}} {{< tab "Rename" >}}

Rename

To rename a cluster replica:

{{% include-syntax file="examples/alter_cluster_replica" example="syntax-rename" %}}

{{< note >}} You cannot rename replicas in system clusters. {{< /note >}}

{{< /tab >}} {{< tab "Change owner" >}}

Change owner

To change the owner of a cluster replica:

{{% include-syntax file="examples/alter_cluster_replica" example="syntax-change-owner" %}}

{{< /tab >}}

{{< /tabs >}}

Privileges

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/alter-cluster-replica" %}}

Example

The following changes the owner of the cluster replica production.r1 to admin. The user running the command must:

  • Be the current owner;
  • Be a member of admin; and
  • Have CREATE privilege on the production cluster.
mzsql
ALTER CLUSTER REPLICA production.r1 OWNER TO admin;