---
title: "ALTER GROUP"
url: "https://docs.yugabyte.com/stable/api/ysql/the-sql-language/statements/dcl_alter_group/"
---

# ALTER GROUP

Use the `ALTER GROUP` statement to alter attributes for a group (role).

## Synopsis

Use the `ALTER GROUP` statement to alter attributes for a group (role). This is added for compatibility with PostgreSQL. Its usage is discouraged. [`ALTER ROLE`](/stable/api/ysql/the-sql-language/statements/dcl_alter_role "ALTER ROLE") is the preferred way to change attributes of a role.

## Syntax

- [![Grammar Icon](/icons/file-lines.svg)Grammar](#grammar-1)
- [![Diagram Icon](/icons/diagram.svg)Diagram](#diagram-1)

```output.ebnf
alter_group ::= ALTER GROUP role_specification { ADD | DROP } USER 
                role_name [ , ... ]

role_specification ::= role_name | CURRENT_USER | SESSION_USER

alter_group_rename ::= ALTER GROUP role_name RENAME TO new_role_name
```

#### alter\_group

ALTERGROUP[role\_specification](#role-specification)ADDDROPUSER,[role\_name](/stable/api/ysql/syntax_resources/grammar_diagrams#role-name)

#### role\_specification

[role\_name](/stable/api/ysql/syntax_resources/grammar_diagrams#role-name)CURRENT\_USERSESSION\_USER

#### alter\_group\_rename

ALTERGROUP[role\_name](/stable/api/ysql/syntax_resources/grammar_diagrams#role-name)RENAMETO[new\_role\_name](/stable/api/ysql/syntax_resources/grammar_diagrams#new-role-name)

See [ALTER ROLE](/stable/api/ysql/the-sql-language/statements/dcl_alter_role "ALTER ROLE") for more details.

`ALTER GROUP` can be used to add or remove roles from a group. Please use [GRANT](/stable/api/ysql/the-sql-language/statements/dcl_grant "GRANT") or [REVOKE](/stable/api/ysql/the-sql-language/statements/dcl_revoke "REVOKE") instead. It can also be used to rename a role.

## See also

- [ALTER ROLE](/stable/api/ysql/the-sql-language/statements/dcl_alter_role "ALTER ROLE")
- [CREATE ROLE](/stable/api/ysql/the-sql-language/statements/dcl_create_role "CREATE ROLE")
- [DROP ROLE](/stable/api/ysql/the-sql-language/statements/dcl_drop_role "DROP ROLE")
- [GRANT](/stable/api/ysql/the-sql-language/statements/dcl_grant "GRANT")
- [REVOKE](/stable/api/ysql/the-sql-language/statements/dcl_revoke "REVOKE")