diff options
| author | Anel Husakovic <anel@mariadb.org> | 2023-01-27 15:53:50 +0100 |
|---|---|---|
| committer | Anel Husakovic <anel@mariadb.org> | 2023-01-27 16:18:04 +0100 |
| commit | 6846913c9fecb7de3eae3470300c16c87c03a591 (patch) | |
| tree | d1380ea72cc9c3398a9f8e75fb527e46826f00fc | |
| parent | 49ee18eb422d7c2bc3b349eef4be9134816b066a (diff) | |
| download | mariadb-git-bb-10.5-anel-anonymous-user-windows-check.tar.gz | |
Testing Windows bb with skip-name-resolvebb-10.5-anel-anonymous-user-windows-check
| -rw-r--r-- | mysql-test/main/anel-master.opt | 1 | ||||
| -rw-r--r-- | mysql-test/main/anel.result | 22 | ||||
| -rw-r--r-- | mysql-test/main/anel.test | 24 |
3 files changed, 47 insertions, 0 deletions
diff --git a/mysql-test/main/anel-master.opt b/mysql-test/main/anel-master.opt new file mode 100644 index 00000000000..ec008a812ce --- /dev/null +++ b/mysql-test/main/anel-master.opt @@ -0,0 +1 @@ +--skip-name-resolve
\ No newline at end of file diff --git a/mysql-test/main/anel.result b/mysql-test/main/anel.result new file mode 100644 index 00000000000..a7f2a519ccd --- /dev/null +++ b/mysql-test/main/anel.result @@ -0,0 +1,22 @@ +# Verify anonymous user on Windows is not 'Administrator' +# +# Test of anonymous user connection +-------------------------------------------------------------- +create role test_role; +grant test_role to ''@localhost; +connect con1,localhost,'',,,$MASTER_MYPORT; +SELECT CURRENT_ROLE; +CURRENT_ROLE +NULL +SET role test_role; +SELECT CURRENT_ROLE; +CURRENT_ROLE +test_role +SET role new_role; +ERROR OP000: Invalid role specification `new_role` +set default role test_role for ''@localhost; +ERROR 42000: You are using MariaDB as an anonymous user and anonymous users are not allowed to modify user settings +connection default; +disconnect con1; +REVOKE all privileges, grant option from ''@localhost; +drop role test_role; diff --git a/mysql-test/main/anel.test b/mysql-test/main/anel.test new file mode 100644 index 00000000000..d31205cff9b --- /dev/null +++ b/mysql-test/main/anel.test @@ -0,0 +1,24 @@ +--echo # Verify anonymous user on Windows is not 'Administrator' +--echo # +--echo # Test of anonymous user connection +--echo -------------------------------------------------------------- +--source include/add_anonymous_users.inc + +create role test_role; +grant test_role to ''@localhost; + +connect(con1,localhost,'',,,$MASTER_MYPORT); +SELECT CURRENT_ROLE; +SET role test_role; +SELECT CURRENT_ROLE; +# user cannot set subset role, since it is not granted explicitly +--error ER_INVALID_ROLE +SET role new_role; +--error ER_PASSWORD_ANONYMOUS_USER +set default role test_role for ''@localhost; + +connection default; +disconnect con1; +REVOKE all privileges, grant option from ''@localhost; +--source include/delete_anonymous_users.inc +drop role test_role;
\ No newline at end of file |