ALTER CLUSTER REPLICA
Use ALTER CLUSTER REPLICA to:
- Rename a cluster replica.
- Change owner of a cluster replica.
Syntax
Rename
To rename a cluster replica:
ALTER CLUSTER REPLICA <name> RENAME TO <new_name>;
| Syntax element | Description |
|---|---|
<name> |
The current name of the cluster replica. |
<new_name> |
The new name of the cluster replica. |
NOTE: You cannot rename replicas in system clusters.
Change owner
To change the owner of a cluster replica:
ALTER CLUSTER REPLICA <name> OWNER TO <new_owner_role>;
| Syntax element | Description |
|---|---|
<name> |
The name of the cluster replica you want to change ownership of. |
<new_owner_role> |
The new owner of the cluster replica. |
To change the owner of a cluster replica, you must be the current owner and have
membership in the <new_owner_role>.
Privileges
The privileges required to execute this statement are:
- Ownership of the cluster replica.
- In addition, to change owners:
- Role membership in
new_owner. CREATEprivileges on the containing cluster.
- Role membership in
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
CREATEprivilege on theproductioncluster.
ALTER CLUSTER REPLICA production.r1 OWNER TO admin;