Debian Codegraph @

mysql-test/suite/information_schema/t/role_table_grants.test

raw
1 --echo # SETUP SCHEMA
2 --source suite/information_schema/include/roles_schema.inc
3
4 --let $TEST_TABLE=ROLE_TABLE_GRANTS
5
6 --echo # USER WITH ROLES.
7
8 --echo #
9 --echo # Case 1: Login as user1
10 --echo #
11 --let USER_NAME=user1
12 --let ROLE_LIST=hr_rules
13 --source suite/information_schema/include/roles_i_s_test.inc
14
15 --echo #
16 --echo # Case 2: Login as user2
17 --echo #
18 --let USER_NAME=user2
19 --let ROLE_LIST=hr_rules
20 --source suite/information_schema/include/roles_i_s_test.inc
21
22 --echo #
23 --echo # Case 3: Login as lead_user1 with mandatory roles.
24 --echo #
25 SET GLOBAL mandatory_roles = 'hr_access';
26 --let USER_NAME=lead_user1
27 --let ROLE_LIST=hr_access
28 --source suite/information_schema/include/roles_i_s_test.inc
29
30 SET GLOBAL activate_all_roles_on_login=on;
31 --let USER_NAME=lead_user1
32 --let ROLE_LIST=hr_access
33 --source suite/information_schema/include/roles_i_s_test.inc
34 SET GLOBAL activate_all_roles_on_login=off;
35
36 SET GLOBAL mandatory_roles = default;
37
38 --echo #
39 --echo # Case 4: Login as lead_user2 with default roles.
40 --echo #
41 SET DEFAULT ROLE hr_access TO lead_user2;
42 --let USER_NAME=lead_user2
43 --let ROLE_LIST=task2_lead
44 --source suite/information_schema/include/roles_i_s_test.inc
45 SET DEFAULT ROLE NONE TO lead_user1;
46
47 --echo #
48 --echo # Case 5: Login as project_lead_user with role graph.
49 --echo #
50 --let USER_NAME=project_lead_user
51 --let ROLE_LIST=hr_access
52 --source suite/information_schema/include/roles_i_s_test.inc
53
54 --echo #
55 --echo # Case 6: Login as project_lead_user with cyclic role graph.
56 --echo #
57 --echo # Form a role graph loop.
58 --echo #
59 --echo # reader
60 --echo # |
61 --echo # V
62 --echo # updater<------------\
63 --echo # | |
64 --echo # |``````````````| |
65 --echo # V V |
66 --echo # task1_lead task2_lead |
67 --echo # | | |
68 --echo # ````````|``````` |
69 --echo # V |
70 --echo # project_lead-----------/
71 --echo #
72 connection default;
73 # GRANT project_lead to updater;
74 INSERT INTO mysql.role_edges (FROM_USER,FROM_HOST,TO_USER,TO_HOST)
75 VALUES('project_lead','%','updater','%');
76 FLUSH PRIVILEGES;
77
78 --let USER_NAME=project_lead_user
79 --let ROLE_LIST=hr_access
80 --source suite/information_schema/include/roles_i_s_test.inc
81
82 REVOKE project_lead FROM updater;
83
84 --echo # Cleanup
85 --source suite/information_schema/include/roles_schema_clean.inc