☰

MySQL 中视图相关的权限

tag-icon • tag-icon mysql
MySQL 中视图相关的权限

如何在 MySQL 中向用户授予与视图相关的权限（不授予所有权限）？当我尝试执行以下操作时出现此错误mysqldump：

mysqldump: Couldn't execute 'show create table `view_household`': SHOW VIEW command denied to user 'backup'@'localhost' for table 'view_household' (1142)

答案1

grant show view on *.* to 'backup'@'localhost'

相关内容