[MDEV-7978] CREATE/ALTER USER as in 5.7 Created: 2015-04-11 Updated: 2020-09-24 Resolved: 2016-03-08 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Authentication and Privilege System |
| Fix Version/s: | 10.2.0 |
| Type: | Task | Priority: | Major |
| Reporter: | Sergei Golubchik | Assignee: | Vicențiu Ciorbaru |
| Resolution: | Fixed | Votes: | 4 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||
| Sprint: | 10.2.0-1, 10.2.0-2, 10.2.0-4, 10.2.0-5, 10.2.0-6, 10.2.0-7 | ||||||||||||
| Description |
|
MySQL 5.7 has extended CREATE/ALTER USER syntax to make a better distinction between privilege management (GRANT/REVOKE) and account management (clauses like IDENTIFIED, REQUIRE SSL, MAX_QUERIES_PER_HOUR, etc). And there's SHOW CREATE USER. We should support this syntax too. Don't forget consistent use of IF [NOT] EXISTS |
| Comments |
| Comment by Vicențiu Ciorbaru [ 2016-01-19 ] |
|
Hi Sergei, I've updated the CREATE/ALTER USER syntax to work according to MySQL's. Can you please review the changes related to this MDEV? I've sent the patch on the mailing list. I initially tried an approach that involved a bit of refactoring. After figuring out that it is not really worth it right now, I came up with the easier implementation just calling replace_user_table. |
| Comment by Vicențiu Ciorbaru [ 2016-03-08 ] |
|
Implemented with: |