Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[ 问题咨询 ]mysql查询表权限验证部分报错 #814

Closed
jdj199222 opened this issue Jul 16, 2020 · 5 comments
Closed

[ 问题咨询 ]mysql查询表权限验证部分报错 #814

jdj199222 opened this issue Jul 16, 2020 · 5 comments
Labels
bug Something isn't working

Comments

@jdj199222
Copy link

问题描述

image

在需要申请权限的账号下这种临时表查询会报错，没有开启query_check，管理员查询正常

版本信息

  • 应用版本/分支：1.7.11
  • 部署方式：手工部署
@jdj199222 jdj199222 added the question Further information is requested label Jul 16, 2020
@LeoQuote
Copy link
Collaborator

看一下后台日志, 大概率是inception 没配置好

@jdj199222
Copy link
Author

看一下后台日志, 大概率是inception 没配置好
如果是inception问题，那么管理员查询应该也会报错，但是只有权限滴需要验证的用户才会报错，且错误是权限那里的错误，这个都是查询了临时表，里面的可以查，外面加个select * from （） t 就报错了

@LeoQuote
Copy link
Collaborator

管理员不校验权限的, 不过inception 那一步

@hhyo
Copy link
Owner

hhyo commented Jul 16, 2020

1.7.11应该走的是goinception解析，复杂查询不支持正常，可以看下查询权限检验那块
#553

@hhyo hhyo added bug Something isn't working and removed question Further information is requested labels Jul 16, 2020
@hhyo
Copy link
Owner

hhyo commented Oct 20, 2020

和 #861 是相同的问题，本地测试可以正常解析，可以确认一下是否解决

@hhyo hhyo closed this as completed Oct 20, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@LeoQuote @hhyo @jdj199222