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/07/09 03:28:25 UTC
[GitHub] [shardingsphere] justbk2015 opened a new issue #11236: grant not support on pg/openGauss
justbk2015 opened a new issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236
## Bug Report
grant privileges to user_test;
this language not support on sharding-proxy
### Which version of ShardingSphere did you use?
opengauss_adapt
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
proxy
### Expected behavior
execute success
### Actual behavior
with exception
### Reason analyze (If you can)
not support this language
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
use gsql to login sharding_db, then execute:
sharding_db=>grant privileges to user_test;
result is ERROR: You have an error in your SQL syntax
### Example codes for reproduce this issue (such as a github link).
see: https://gitee.com/opengauss/openGauss-distributed-solutions/issues/I3YPSM?from=project-issue
--
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] justbk2015 commented on issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
justbk2015 commented on issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236#issuecomment-881122218
> @justbk2015
> I saw you have this sql:
> grant privileges to user_test;
> I don't konw if `privileges` is a role or a keyword.
> if it is a role ,then sharding-proxy is supported.
> if it is a keyword ,then the PG official document is not support.
> see https://www.postgresql.org/docs/13/sql-grant.html
I spell some error, please use `grant all privileges to user_role` instead.
--
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] tuichenchuxin commented on issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236#issuecomment-880599287
@justbk2015
I saw you have this sql:
grant privileges to user_test;
I don't konw if `privileges` is a role or a keyword.
if it is a role ,then sharding-proxy is supported.
if it is a keyword ,then the PG official document is not support.
see https://www.postgresql.org/docs/13/sql-grant.html
--
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] sandynz closed issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
sandynz closed issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236
--
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] SteNicholas commented on issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
SteNicholas commented on issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236#issuecomment-876947161
@justbk2015 , `GRANT` syntax isn't supported in PG/OpenGauss. Do you have interest to contribute this adapter to PG/OpenGauss?
--
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] justbk2015 commented on issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
justbk2015 commented on issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236#issuecomment-876965456
> @justbk2015 , `GRANT` syntax isn't supported in PG/OpenGauss. Do you have interest to contribute this adapter to PG/OpenGauss?
I'd like to try it
--
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] sandynz closed issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
sandynz closed issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236
--
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] justbk2015 commented on issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
justbk2015 commented on issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236#issuecomment-881128478
> @justbk2015
> grant all privileges to user_role is not supported by pg official document,
> may be 'grant all privileges on t_order to user_role'
I will try and soon reponse 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] sandynz commented on issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236#issuecomment-928600926
@justbk2015 feedback it works. Closed.
--
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] sandynz commented on issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236#issuecomment-928600926
@justbk2015 feedback it works. Closed.
--
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] tuichenchuxin commented on issue #11236: grant not support on pg/openGauss
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #11236:
URL: https://github.com/apache/shardingsphere/issues/11236#issuecomment-881125607
@justbk2015
grant all privileges to user_role is not supported by pg official document,
may be 'grant all privileges on t_order to user_role'
--
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