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

[ 功能建议 ]SQL查询权限控制问题 #507

Closed
gitzhuyongfu opened this issue Nov 9, 2019 · 2 comments
Closed

[ 功能建议 ]SQL查询权限控制问题 #507

gitzhuyongfu opened this issue Nov 9, 2019 · 2 comments
Labels
ease of use enhancement New feature or request

Comments

@gitzhuyongfu
Copy link

目前遇到的问题/使用障碍

1.申请了表查询的权限的时候，如果此时没有申请数据库权限，那么无法进行表查询。
2.如果申请了数据库权限，那么，这个数据库下的所有表都能进行查询，此时就无法限制对表的查询控制

希望如何解决/实现它

1.如果申请了表查询权限，那么就可以查询此数据库的此表，其他表无查询权限
2.如果申请了数据库权限，则可以允许查询此数据库下的所有表数据而无需再进行表查询的权限申请！

其他信息

如果有其他类似的产品功能或者图片信息，可在此提交
@gitzhuyongfu gitzhuyongfu changed the title [ 功能建议 ]SQL查询权限 [ 功能建议 ]SQL查询权限控制问题 Nov 9, 2019
@hhyo
Copy link
Owner

hhyo commented Nov 9, 2019

感谢反馈

其实目前就是这样实现的，只不过SQL解析优先用的inception，不一定可以解析出所有语句的库表信息，当遇到解析不出的语句时，会再次去用sqlparse获取库信息判断库权限，从而出现上面描述的现象，是一种折中的处理方式

有改造意向，不过没确定最终方案，可参考 #145

@weekly-digest weekly-digest bot mentioned this issue Nov 10, 2019
Closed
@stale stale bot added the wontfix This will not be worked on label Nov 12, 2019
@hhyo hhyo added ease of use enhancement New feature or request and removed wontfix This will not be worked on labels Nov 12, 2019
Repository owner deleted a comment from stale bot Nov 12, 2019
@hhyo hhyo mentioned this issue Dec 1, 2019
Merged
@hhyo
Copy link
Owner

hhyo commented Dec 7, 2019

已处理

@hhyo hhyo closed this as completed Dec 7, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
ease of use enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@hhyo @gitzhuyongfu