Support ALTER USER ... DEFAULT ROLE
Open
type/feature-request
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Feature Request
**Is your feature request related to a problem? Please describe:**
TiDB supports only `SET DEFAULT ROLE`.
**Describe the feature you'd like:**
MySQL supports `ALTER USER u1@localhost DEFAULT ROLE r1`
[ALTER USER](https://dev.mysql.com/doc/refman/8.0/en/alter-user.html) can set the default for only a single user, whereas [SET DEFAULT ROLE](https://dev.mysql.com/doc/refman/8.0/en/set-default-role.html) can set the default for multiple users.
Contributor guide
Assessment
This issue has not been assessed yet.