dbeaver / dbeaver/dbeaver

Add dropdown to choose a default role for MySQL 8.0 user

Open
#36,220 1 comment 0 reactions 0 assignees View on GitHub
wait for votes x:mysql xf:metadata
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

**Is your feature request related to a problem? Please describe.**
In MySQL 8.0.x a user can be set a default role using ALTER USER ... DEFAULT ROLE command.

**Describe the solution you'd like**
Add a dropdown box for choosing a default role from a list in the user properties screen.
The role should be granted and set as default when saving the user properties.

**Describe alternatives you've considered**
Running:
```
GRANT [role] TO [user];
ALTER USER [user] DEFAULT ROLE [role];
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.