diff options
| author | Anel Husakovic <anel@mariadb.org> | 2019-07-04 22:38:47 -0700 |
|---|---|---|
| committer | Anel Husakovic <anel@mariadb.org> | 2019-07-24 23:19:43 -0700 |
| commit | 55d8ff0de8168d3b7d465644dc93dca01f53f4f6 (patch) | |
| tree | afe09128f77ad598a41647caabbc0652e011ac08 /mysql-test/main/grant.result | |
| parent | 0d99ccea1e5d7dab3ece44071c10f5b37f634201 (diff) | |
| download | mariadb-git-55d8ff0de8168d3b7d465644dc93dca01f53f4f6.tar.gz | |
MDEV-19948 `SHOW GRANTS FOR user` return privileges individually
Diffstat (limited to 'mysql-test/main/grant.result')
| -rw-r--r-- | mysql-test/main/grant.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/main/grant.result b/mysql-test/main/grant.result index 31ea932445d..ccbabab8019 100644 --- a/mysql-test/main/grant.result +++ b/mysql-test/main/grant.result @@ -2760,3 +2760,34 @@ DROP USER dummy@localhost; # # End of 10.2 tests # +# +# Start of 10.3 tests +# +# +# MDEV-19948 'show grants' return privileges individually +# +SET @had_user_delete_history_priv := 0; +SELECT @had_user_delete_history_priv :=1 FROM mysql.user WHERE Delete_history_priv LIKE '%'; +@had_user_delete_history_priv :=1 +1 +1 +1 +1 +ALTER TABLE mysql.user DROP COLUMN Delete_history_priv; +FLUSH PRIVILEGES; +CREATE USER ten2; +GRANT ALL ON *.* TO ten2; +SHOW GRANTS FOR ten2; +Grants for ten2@% +GRANT ALL PRIVILEGES ON *.* TO 'ten2'@'%' +FLUSH PRIVILEGES; +SHOW GRANTS FOR ten2; +Grants for ten2@% +GRANT ALL PRIVILEGES ON *.* TO 'ten2'@'%' +DROP USER ten2; +ALTER TABLE mysql.user ADD Delete_history_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL DEFAULT 'N' after Create_tablespace_priv; +UPDATE mysql.user SET Delete_history_priv = Super_priv WHERE @had_user_delete_history_priv = 1; +FLUSH PRIVILEGES; +# +# End of 10.3 tests +# |