Home
last modified time | relevance | path

Searched refs:test_role (Results 51 – 75 of 166) sorted by relevance

1234567

/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/roles/
H A Dcreate_and_drop_role_invalid_user_table.result8 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 Dcreate_and_drop_role_invalid_user_table.test22 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 Dcurrent_role_view-12666.result3 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 Drole_case_sensitive-10744.result9 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 Dset_default_role_invalid.result2 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 Dcreate_and_drop_role_invalid_user_table.result8 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 Dcreate_and_drop_role_invalid_user_table.test22 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 Dcurrent_role_view-12666.result3 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 Drole_case_sensitive-10744.result9 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 Dcreate_and_drop_role_invalid_user_table.result7 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 Dcreate_and_drop_role_invalid_user_table.test21 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 Dcurrent_role_view-12666.result3 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 Drole_case_sensitive-10744.result9 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 Dset_default_role_invalid.result2 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 Dcreate_and_drop_role_invalid_user_table.result7 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 Dcreate_and_drop_role_invalid_user_table.test21 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 Dcurrent_role_view-12666.result3 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 Drole_case_sensitive-10744.result9 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 Dcreate_and_drop_role_invalid_user_table.test22 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 Dcurrent_role_view-12666.result3 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 Drole_case_sensitive-10744.result9 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 Dset_default_role_invalid.result2 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 Dcreate_and_drop_role_invalid_user_table.test22 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 Dcurrent_role_view-12666.result3 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 Drole_case_sensitive-10744.result9 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;

1234567