Debian Codegraph @

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

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