sql - 什么是错误 mysql (#1356)？

Question

我创建一个 View :

CREATE OR REPLACE VIEW AuthorizationTrainer AS 
  SELECT Person.id, Person.login as nick, Person.password as pass 
  FROM TABLE2,Person 
  WHERE TABLE2.id_Person = Person.id

然后创建赠款:

GRANT SELECT ON Teachprog.AuthorizationTrainer TO 'Trener'@'%'

SELECT id,nick FROM AuthorizationTrainer - 有效

SELECT id,nick,pass FROM AuthorizationTrainer - 产生错误:

fly error: #1356 - View 'Teachprog.AuthorizationTrainer' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Answer 1

您是否检查了底层 TABLE2 和 Person 表的授权？您可以在 View 上授予您想要的所有选择权限，但如果用户被阻止访问 Person 中的 pass 字段，您将收到此错误。检查:

show grants for trener@%