ALTER ROLE

Renames an existing role.

You cannot use ALTER ROLE to rename a role that was added to the Vertica database with the LDAPLink service.

Syntax

ALTER ROLE name RENAME TO new‑name

Parameters

name

The role to rename.

new‑name

The role's new name.

Privileges

Superuser

Example

=> ALTER ROLE applicationadministrator RENAME TO appadmin;
ALTER ROLE