[MDEV-31832] PUBLIC user Created: 2023-08-03 Updated: 2023-08-04 Resolved: 2023-08-03 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Authentication and Privilege System |
| Affects Version/s: | 11.2.0 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Kathryn Sizemore | Assignee: | Sergei Golubchik |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Description |
|
In Community versions, A PUBLIC role is created and appears to be part of the Test DB scripts. But it's never removed and mariadb_secure_installation does not remove it. Can we remove this role? |
| Comments |
| Comment by Sergei Golubchik [ 2023-08-03 ] |
|
PUBLIC is not a user. GRANT TO PUBLIC is a special standard syntax to grant a privilege to all users, it does not imply that there is a user named "PUBLIC". There is a row in the mysql.global_priv for it and you can remove it, if you'd like. But it'll be recreated by the server automatically when needed. |