You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/09/26 03:13:54 UTC
[GitHub] [shardingsphere] roodkcab opened a new issue #12717: master branch native table privilege check exception
roodkcab opened a new issue #12717:
URL: https://github.com/apache/shardingsphere/issues/12717
## Bug Report
### Which version of ShardingSphere did you use?
master/5.0.0-RC1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
native table privilege check should work without any exception
### Actual behavior
got exception java.sql.SQLException: Column 'user' not found.
### Reason analyze (If you can)
TABLE_PRIVILEGE_SQL should be "SELECT Db, Table_name, Table_priv, user, host FROM mysql.tables_priv WHERE (user, host) in (%s)", i.e. user and host must be included in selected column.
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
grand any table privilege on user in server.yaml will trigger this bug
### Example codes for reproduce this issue (such as a github link).
none
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #12717: master branch native table privilege check exception
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #12717:
URL: https://github.com/apache/shardingsphere/issues/12717
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #12717: master branch native table privilege check exception
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12717:
URL: https://github.com/apache/shardingsphere/issues/12717#issuecomment-927450196
> @RaigorJiang I can try to investigate.
@lanchengx Thank you.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #12717: master branch native table privilege check exception
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12717:
URL: https://github.com/apache/shardingsphere/issues/12717#issuecomment-1008627573
For #12752 and #13911,
`Native` authority provider will be removed later, I just close this issue.
Thank you all!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #12717: master branch native table privilege check exception
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12717:
URL: https://github.com/apache/shardingsphere/issues/12717#issuecomment-927250512
@roodkcab
Thank you for your feedback. I ran some tests and the results are as follows:
```sql
mysql> grant select, insert, update, delete on sharding_db.t_order to user12717@%;
ERROR 1235 (42000): This version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your SQL syntax'
mysql> grant select, insert, update, delete on sharding_db.t_order to user12717;
ERROR 1146 (42S02): Table 'sharding_db.t_order' doesn't exist
mysql> grant select, insert, update, delete on t_order to user12717;
Query OK, 0 rows affected (0.04 sec)
```
There are indeed problems that need to be improved.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] lanchengx commented on issue #12717: master branch native table privilege check exception
Posted by GitBox <gi...@apache.org>.
lanchengx commented on issue #12717:
URL: https://github.com/apache/shardingsphere/issues/12717#issuecomment-927445293
@RaigorJiang I can try to investigate.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #12717: master branch native table privilege check exception
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12717:
URL: https://github.com/apache/shardingsphere/issues/12717#issuecomment-927224233
Hi @roodkcab
Could you show some exception log?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org