Description:
when a user U, creates a view V2 which references a view V1, and U does not have access
to 'show create table' on V1, an attempt by root to 'show create table V2' will also
fail.
this is a serious bug because it prevents the 'mysqldump' utility from dumping the
affected table.
0/root@zedler:~>mysqldump -uroot -p u_stridvall >/dev/null
Enter password:
mysqldump: mysqldump: Couldn't execute 'show create table `pages_changed_since_dump`':
SHOW VIEW command denied to user 'stridvall'@'login-services.zedler.knams.wikimedia.org'
for table 'recentchanges' (1142)
root@localhost:u_stridvall> show grants;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost
|
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
'.............................................................' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
root@localhost:u_stridvall> show create table pages_changed_since_dump;
ERROR 1142 (42000): SHOW VIEW command denied to user
'stridvall'@'login-services.zedler.knams.wikimedia.org' for table 'recentchanges'
How to repeat:
See description.
Description: when a user U, creates a view V2 which references a view V1, and U does not have access to 'show create table' on V1, an attempt by root to 'show create table V2' will also fail. this is a serious bug because it prevents the 'mysqldump' utility from dumping the affected table. 0/root@zedler:~>mysqldump -uroot -p u_stridvall >/dev/null Enter password: mysqldump: mysqldump: Couldn't execute 'show create table `pages_changed_since_dump`': SHOW VIEW command denied to user 'stridvall'@'login-services.zedler.knams.wikimedia.org' for table 'recentchanges' (1142) root@localhost:u_stridvall> show grants; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '.............................................................' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) root@localhost:u_stridvall> show create table pages_changed_since_dump; ERROR 1142 (42000): SHOW VIEW command denied to user 'stridvall'@'login-services.zedler.knams.wikimedia.org' for table 'recentchanges' How to repeat: See description.