Debian Codegraph @

mysql-test/suite/auth_sec/t/user_attributes_column.test

raw
1 ###############################################################################
2 # Verify the impact on JSON column due to combinations of #
3 # various features pertaining to it. #
4 # #
5 ###############################################################################
6
7 # Save the initial number of concurrent sessions
8 --source include/count_sessions.inc
9 --disable_query_log
10 let $saved_partial_revokes = `SELECT @@global.partial_revokes`;
11 --enable_query_log
12
13 --echo #
14 --echo # 1. Column must remain intact due to Global GRANT.
15 --echo #
16 SET GLOBAL partial_revokes = ON;
17 CREATE USER foo;
18 SELECT user, user_attributes FROM mysql.user WHERE user = 'foo';
19 GRANT INSERT ON *.* TO foo;
20 SELECT user, user_attributes FROM mysql.user WHERE user = 'foo';
21 --echo #
22 --echo # 2. Column must remain intact after Add/Drop partial revokes from user.
23 --echo #
24 REVOKE INSERT ON mysql.* FROM foo;
25 GRANT INSERT ON mysql.* TO foo;
26 SELECT user, user_attributes FROM mysql.user WHERE user = 'foo';
27 DROP USER foo;
28 --echo #
29 --echo # 3. Adding/removing partial revokes must not impact other attributes
30 --echo #
31 CREATE USER foo@localhost FAILED_LOGIN_ATTEMPTS 4 PASSWORD_LOCK_TIME 6;
32 ALTER USER foo@localhost ATTRIBUTE '{"key":"value"}';
33 ALTER USER foo@localhost COMMENT 'Added key/value pair';
34 SELECT user, user_attributes FROM mysql.user WHERE user='foo';
35
36 GRANT SELECT ON *.* TO foo@localhost;
37 REVOKE SELECT ON mysql.* FROM foo@localhost;
38 --echo # Pre-existing attributes must not be changed.
39 SELECT user, user_attributes FROM mysql.user WHERE user='foo';
40
41 GRANT SELECT ON mysql.* TO foo@localhost;
42 --echo # Partial revoke must be removed.
43 SELECT user, user_attributes FROM mysql.user WHERE user='foo';
44 DROP USER foo@localhost;
45
46 # Cleanup
47 --disable_query_log
48 eval SET GLOBAL partial_revokes = $saved_partial_revokes;
49 --enable_query_log
50
51 # Wait till all disconnects are completed
52 --source include/wait_until_count_sessions.inc