diff options
Diffstat (limited to 'mysql-test/main/lock_view.result')
| -rw-r--r-- | mysql-test/main/lock_view.result | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/mysql-test/main/lock_view.result b/mysql-test/main/lock_view.result index 48c45dcf23d..82aeb074ebf 100644 --- a/mysql-test/main/lock_view.result +++ b/mysql-test/main/lock_view.result @@ -154,13 +154,13 @@ USE `mysqltest3`; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -connect inv,localhost,invoker; +connect inv,localhost,invoker,,"*NO-ONE*"; lock table mysqltest3.v3 write; ERROR 42000: Access denied for user 'invoker'@'localhost' to database 'mysqltest3' disconnect inv; connection default; grant lock tables on mysqltest3.* to invoker@localhost; -connect inv,localhost,invoker; +connect inv,localhost,invoker,,"*NO-ONE*"; show create view mysqltest3.v3; View Create View character_set_client collation_connection v3 CREATE ALGORITHM=UNDEFINED DEFINER=`definer`@`localhost` SQL SECURITY DEFINER VIEW `mysqltest3`.`v3` AS select `v2`.`a` AS `a` from `mysqltest2`.`v2` latin1 latin1_swedish_ci @@ -187,7 +187,6 @@ information_schema mysqltest1 mysqltest2 performance_schema -test lock table mysqltest3.v3ps write; select * from mysqltest3.v3ps; user @@ -201,7 +200,7 @@ select * from mysqltest3.v3nt; disconnect inv; connection default; grant lock tables on mysqltest2.* to invoker@localhost; -connect inv,localhost,invoker; +connect inv,localhost,invoker,,"*NO-ONE*"; lock table mysqltest3.v3 write; ERROR HY000: View 'mysqltest3.v3' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them lock table mysqltest3.v3i write; @@ -209,7 +208,7 @@ ERROR HY000: View 'mysqltest3.v3i' references invalid table(s) or column(s) or f disconnect inv; connection default; grant lock tables on mysqltest1.* to definer@localhost; -connect inv,localhost,invoker; +connect inv,localhost,invoker,,"*NO-ONE*"; lock table mysqltest3.v3 write; select * from mysqltest3.v3; a @@ -218,7 +217,7 @@ ERROR HY000: View 'mysqltest3.v3i' references invalid table(s) or column(s) or f disconnect inv; connection default; grant lock tables on mysqltest1.* to invoker@localhost; -connect inv,localhost,invoker; +connect inv,localhost,invoker,,"*NO-ONE*"; lock table mysqltest3.v3i write; select * from mysqltest3.v3i; a |