diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-08-10 17:56:08 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-08-10 17:56:08 +0300 |
| commit | 0025eb3f963fdca88028ff14a27d9b9638079337 (patch) | |
| tree | 09ae14a45e658e6783b8a3c57a955a931194c03e /mysql-test/main/grant5.result | |
| parent | c19335ea5359923c918b07ef9892c14408414b4d (diff) | |
| parent | 4668e079eed635c9ff19a39e584202d3a4e590c1 (diff) | |
| download | mariadb-git-0025eb3f963fdca88028ff14a27d9b9638079337.tar.gz | |
Merge mariadb-10.3.24
Diffstat (limited to 'mysql-test/main/grant5.result')
| -rw-r--r-- | mysql-test/main/grant5.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/grant5.result b/mysql-test/main/grant5.result index 6f474e3d52a..8fec77cdba4 100644 --- a/mysql-test/main/grant5.result +++ b/mysql-test/main/grant5.result @@ -25,6 +25,19 @@ ERROR HY000: Table 'user' was not locked with LOCK TABLES REVOKE PROCESS ON *.* FROM u; ERROR HY000: Table 'user' was not locked with LOCK TABLES DROP TABLE t1; +create database mysqltest1; +use mysqltest1; +create table t1(id int); +insert t1 values(2); +create user u1@localhost; +grant select on mysqltest1.t1 to u1@localhost; +grant update on mysqltest1.* to u1@localhost; +connect u1, localhost, u1; +update mysqltest1.t1 set id=1 where id=2; +connection default; +disconnect u1; +drop user u1@localhost; +drop database mysqltest1; # # MDEV-20076: SHOW GRANTS does not quote role names properly # |