| 1 |
create user foo@localhost; |
| 2 |
grant create user on *.* to foo@localhost; |
| 3 |
create user current_user; |
| 4 |
ERROR HY000: Operation CREATE USER failed for CURRENT_USER |
| 5 |
create user current_role; |
| 6 |
ERROR HY000: Operation CREATE USER failed for CURRENT_ROLE |
| 7 |
create role current_user; |
| 8 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_user' at line 1 |
| 9 |
create role current_role; |
| 10 |
ERROR HY000: Operation CREATE ROLE failed for CURRENT_ROLE |
| 11 |
drop user current_user; |
| 12 |
drop user current_role; |
| 13 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_role' at line 1 |
| 14 |
drop role current_user; |
| 15 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_user' at line 1 |
| 16 |
drop role current_role; |
| 17 |
ERROR HY000: Operation DROP ROLE failed for CURRENT_ROLE |
| 18 |
show warnings; |
| 19 |
Level Code Message |
| 20 |
Error 1446 Invalid definer |
| 21 |
Error 1396 Operation DROP ROLE failed for CURRENT_ROLE |
| 22 |
create role r1; |
| 23 |
grant r1 to current_user; |
| 24 |
set role r1; |
| 25 |
select current_role(); |
| 26 |
current_role() |
| 27 |
r1 |
| 28 |
create user current_role; |
| 29 |
ERROR HY000: Operation CREATE USER failed for CURRENT_ROLE |
| 30 |
create role current_role; |
| 31 |
ERROR HY000: Operation CREATE ROLE failed for CURRENT_ROLE |
| 32 |
drop user current_role; |
| 33 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'current_role' at line 1 |
| 34 |
drop role current_role; |