diff options
Diffstat (limited to 'mysql-test/r/acl_roles_admin.result')
| -rw-r--r-- | mysql-test/r/acl_roles_admin.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/acl_roles_admin.result b/mysql-test/r/acl_roles_admin.result new file mode 100644 index 00000000000..31879eced21 --- /dev/null +++ b/mysql-test/r/acl_roles_admin.result @@ -0,0 +1,19 @@ +create user foo@localhost; +create role role1; +create role role2 with admin current_user; +create role role3 with admin current_role; +create role role4 with admin root@localhost; +create role role5 with admin foo@localhost; +create role role6 with admin foo@bar; +create user bar with admin current_user; +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 'admin current_user' at line 1 +grant role1 to foo@localhost with admin option; +grant role2 to role1; +grant role3 to role4 with admin option; +grant select on *.* to foo@localhost with admin option; +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 'admin option' at line 1 +revoke role1 from foo@localhost; +revoke admin option for role3 from role4; +revoke admin option for role2 from role1; +drop role role1, role2, role3, role4, role5, role6; +drop user foo@localhost; |