/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/roles/ |
H A D | create_and_drop_role_invalid_user_table.result | 8 create role test_role; 10 drop role test_role; 11 ERROR HY000: Operation DROP ROLE failed for 'test_role' 15 create role test_role; 17 grant test_role to test_user@localhost; 18 set default role test_role for root@localhost; 19 drop role test_role; 28 create role test_role; 29 drop role test_role;
|
H A D | create_and_drop_role_invalid_user_table.test | 22 create role test_role; 24 drop role test_role; 30 create role test_role; 32 grant test_role to test_user@localhost; 35 set default role test_role for root@localhost; 36 drop role test_role; 48 create role test_role; 49 drop role test_role;
|
H A D | current_role_view-12666.result | 3 CREATE ROLE test_role; 4 GRANT test_role TO has_role@'localhost'; 11 INSERT INTO view_role_test VALUES (1, 'test_role'); 42 SET ROLE test_role; 48 test_role 68 1 test_role 71 1 test_role 74 1 test_role 77 1 test_role 80 1 test_role [all …]
|
H A D | role_case_sensitive-10744.result | 9 create role test_role; 16 test_role 20 grant select on secret_db.* to test_role; 21 grant test_role to test_user; 24 GRANT `test_role` TO `test_user`@`%` 33 GRANT `test_role` TO `test_user`@`%` 49 set role test_role; 58 drop role test_role;
|
H A D | set_default_role_invalid.result | 2 create role test_role; 4 grant select on *.* to test_role; 5 grant test_role to test_user@localhost; 8 GRANT `test_role` TO `test_user`@`localhost` 16 set default role test_role; 21 test_user localhost test_role 26 GRANT SELECT ON *.* TO `test_role` 30 test_user localhost test_role 35 test_user localhost test_role 36 revoke test_role from test_user@localhost; [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/roles/ |
H A D | create_and_drop_role_invalid_user_table.result | 8 create role test_role; 10 drop role test_role; 11 ERROR HY000: Operation DROP ROLE failed for 'test_role' 15 create role test_role; 17 grant test_role to test_user@localhost; 18 set default role test_role for root@localhost; 19 drop role test_role; 28 create role test_role; 29 drop role test_role;
|
H A D | create_and_drop_role_invalid_user_table.test | 22 create role test_role; 24 drop role test_role; 30 create role test_role; 32 grant test_role to test_user@localhost; 35 set default role test_role for root@localhost; 36 drop role test_role; 48 create role test_role; 49 drop role test_role;
|
H A D | current_role_view-12666.result | 3 CREATE ROLE test_role; 4 GRANT test_role TO has_role@'localhost'; 11 INSERT INTO view_role_test VALUES (1, 'test_role'); 42 SET ROLE test_role; 48 test_role 68 1 test_role 71 1 test_role 74 1 test_role 77 1 test_role 80 1 test_role [all …]
|
H A D | role_case_sensitive-10744.result | 9 create role test_role; 16 test_role 20 grant select on secret_db.* to test_role; 21 grant test_role to test_user; 24 GRANT `test_role` TO `test_user`@`%` 33 GRANT `test_role` TO `test_user`@`%` 49 set role test_role; 58 drop role test_role;
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/roles/ |
H A D | create_and_drop_role_invalid_user_table.result | 7 create role test_role; 9 drop role test_role; 10 ERROR HY000: Operation DROP ROLE failed for 'test_role' 14 create role test_role; 16 grant test_role to test_user@localhost; 17 set default role test_role for root@localhost; 19 drop role test_role; 28 create role test_role; 29 drop role test_role;
|
H A D | create_and_drop_role_invalid_user_table.test | 21 create role test_role; 23 drop role test_role; 29 create role test_role; 31 grant test_role to test_user@localhost; 34 set default role test_role for root@localhost; 35 drop role test_role; 47 create role test_role; 48 drop role test_role;
|
H A D | current_role_view-12666.result | 3 CREATE ROLE test_role; 4 GRANT test_role TO has_role@'localhost'; 11 INSERT INTO view_role_test VALUES (1, 'test_role'); 42 SET ROLE test_role; 48 test_role 68 1 test_role 71 1 test_role 74 1 test_role 77 1 test_role 80 1 test_role [all …]
|
H A D | role_case_sensitive-10744.result | 9 create role test_role; 16 test_role 20 grant select on secret_db.* to test_role; 21 grant test_role to test_user; 24 GRANT `test_role` TO `test_user`@`%` 33 GRANT `test_role` TO `test_user`@`%` 49 set role test_role; 58 drop role test_role;
|
H A D | set_default_role_invalid.result | 2 create role test_role; 4 grant select on *.* to test_role; 5 grant test_role to test_user@localhost; 8 GRANT `test_role` TO `test_user`@`localhost` 16 set default role test_role; 21 test_user localhost test_role 26 GRANT SELECT ON *.* TO `test_role` 30 test_user localhost test_role 35 test_user localhost test_role 36 revoke test_role from test_user@localhost; [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/roles/ |
H A D | create_and_drop_role_invalid_user_table.result | 7 create role test_role; 9 drop role test_role; 10 ERROR HY000: Operation DROP ROLE failed for 'test_role' 14 create role test_role; 16 grant test_role to test_user@localhost; 17 set default role test_role for root@localhost; 19 drop role test_role; 28 create role test_role; 29 drop role test_role;
|
H A D | create_and_drop_role_invalid_user_table.test | 21 create role test_role; 23 drop role test_role; 29 create role test_role; 31 grant test_role to test_user@localhost; 34 set default role test_role for root@localhost; 35 drop role test_role; 47 create role test_role; 48 drop role test_role;
|
H A D | current_role_view-12666.result | 3 CREATE ROLE test_role; 4 GRANT test_role TO has_role@'localhost'; 11 INSERT INTO view_role_test VALUES (1, 'test_role'); 42 SET ROLE test_role; 48 test_role 68 1 test_role 71 1 test_role 74 1 test_role 77 1 test_role 80 1 test_role [all …]
|
H A D | role_case_sensitive-10744.result | 9 create role test_role; 16 test_role 20 grant select on secret_db.* to test_role; 21 grant test_role to test_user; 24 GRANT `test_role` TO `test_user`@`%` 33 GRANT `test_role` TO `test_user`@`%` 49 set role test_role; 58 drop role test_role;
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/roles/ |
H A D | create_and_drop_role_invalid_user_table.test | 22 create role test_role; 24 drop role test_role; 30 create role test_role; 32 grant test_role to test_user@localhost; 35 set default role test_role for root@localhost; 36 drop role test_role; 48 create role test_role; 49 drop role test_role;
|
H A D | current_role_view-12666.result | 3 CREATE ROLE test_role; 4 GRANT test_role TO has_role@'localhost'; 11 INSERT INTO view_role_test VALUES (1, 'test_role'); 42 SET ROLE test_role; 48 test_role 68 1 test_role 71 1 test_role 74 1 test_role 77 1 test_role 80 1 test_role [all …]
|
H A D | role_case_sensitive-10744.result | 9 create role test_role; 16 test_role 20 grant select on secret_db.* to test_role; 21 grant test_role to test_user; 24 GRANT `test_role` TO `test_user`@`%` 33 GRANT `test_role` TO `test_user`@`%` 49 set role test_role; 58 drop role test_role;
|
H A D | set_default_role_invalid.result | 2 create role test_role; 4 grant select on *.* to test_role; 5 grant test_role to test_user@localhost; 8 GRANT `test_role` TO `test_user`@`localhost` 16 set default role test_role; 21 test_user localhost test_role 26 GRANT SELECT ON *.* TO `test_role` 30 test_user localhost test_role 35 test_user localhost test_role 36 revoke test_role from test_user@localhost; [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/roles/ |
H A D | create_and_drop_role_invalid_user_table.test | 22 create role test_role; 24 drop role test_role; 30 create role test_role; 32 grant test_role to test_user@localhost; 35 set default role test_role for root@localhost; 36 drop role test_role; 48 create role test_role; 49 drop role test_role;
|
H A D | current_role_view-12666.result | 3 CREATE ROLE test_role; 4 GRANT test_role TO has_role@'localhost'; 11 INSERT INTO view_role_test VALUES (1, 'test_role'); 42 SET ROLE test_role; 48 test_role 68 1 test_role 71 1 test_role 74 1 test_role 77 1 test_role 80 1 test_role [all …]
|
H A D | role_case_sensitive-10744.result | 9 create role test_role; 16 test_role 20 grant select on secret_db.* to test_role; 21 grant test_role to test_user; 24 GRANT `test_role` TO `test_user`@`%` 33 GRANT `test_role` TO `test_user`@`%` 49 set role test_role; 58 drop role test_role;
|