Debian Codegraph @

mysql-test/suite/auth_sec/r/user_attributes_column.result

raw
1 #
2 # 1. Column must remain intact due to Global GRANT.
3 #
4 SET GLOBAL partial_revokes = ON;
5 CREATE USER foo;
6 SELECT user, user_attributes FROM mysql.user WHERE user = 'foo';
7 user user_attributes
8 foo NULL
9 GRANT INSERT ON *.* TO foo;
10 SELECT user, user_attributes FROM mysql.user WHERE user = 'foo';
11 user user_attributes
12 foo NULL
13 #
14 # 2. Column must remain intact after Add/Drop partial revokes from user.
15 #
16 REVOKE INSERT ON mysql.* FROM foo;
17 GRANT INSERT ON mysql.* TO foo;
18 SELECT user, user_attributes FROM mysql.user WHERE user = 'foo';
19 user user_attributes
20 foo NULL
21 DROP USER foo;
22 #
23 # 3. Adding/removing partial revokes must not impact other attributes
24 #
25 CREATE USER foo@localhost FAILED_LOGIN_ATTEMPTS 4 PASSWORD_LOCK_TIME 6;
26 ALTER USER foo@localhost ATTRIBUTE '{"key":"value"}';
27 ALTER USER foo@localhost COMMENT 'Added key/value pair';
28 SELECT user, user_attributes FROM mysql.user WHERE user='foo';
29 user user_attributes
30 foo {"metadata": {"key": "value", "comment": "Added key/value pair"}, "Password_locking": {"failed_login_attempts": 4, "password_lock_time_days": 6}}
31 GRANT SELECT ON *.* TO foo@localhost;
32 REVOKE SELECT ON mysql.* FROM foo@localhost;
33 # Pre-existing attributes must not be changed.
34 SELECT user, user_attributes FROM mysql.user WHERE user='foo';
35 user user_attributes
36 foo {"metadata": {"key": "value", "comment": "Added key/value pair"}, "Restrictions": [{"Database": "mysql", "Privileges": ["SELECT"]}], "Password_locking": {"failed_login_attempts": 4, "password_lock_time_days": 6}}
37 GRANT SELECT ON mysql.* TO foo@localhost;
38 # Partial revoke must be removed.
39 SELECT user, user_attributes FROM mysql.user WHERE user='foo';
40 user user_attributes
41 foo {"metadata": {"key": "value", "comment": "Added key/value pair"}, "Password_locking": {"failed_login_attempts": 4, "password_lock_time_days": 6}}
42 DROP USER foo@localhost;