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/30 03:23:03 UTC
[GitHub] [shardingsphere] CrackerSuperior opened a new issue #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
CrackerSuperior opened a new issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838
Version: 5.0.0-RC1
``` sql
mysql> create user 'test'@'%' identified by 'test';
ERROR 1396 (HY000): Operation CREATE USER failed for 'test'@'%'
```
Are there any examples of "sharding agent" user management or user permissions? I configured which logic libraries the user can use according to the 4.x version, but it seems to be invalid.
--
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 #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930863616
> This seems to only limit the databases that users can use. Is there any configuration that can restrict user permissions, for example, I want a user to have only "SELECT" permissions
Can't do it now, this feature is being planned.
--
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 #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930825689
> Oh, this is exactly what I need, thanks!
Glad to help you. So can we close this 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] CrackerSuperior closed issue #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
CrackerSuperior closed issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838
--
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 #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930750480
Please provide configuration information:
What is the provider type of AUTHORITY in server.yaml?
--
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] CrackerSuperior commented on issue #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930831148
> > Oh, this is exactly what I need, thanks!
>
> Glad to help you. So can we close this issue?
This seems to only limit the databases that users can use. Is there any configuration that can restrict user permissions, for example, I want a user to have only "SELECT" permissions
--
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] CrackerSuperior commented on issue #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930864702
> > This seems to only limit the databases that users can use. Is there any configuration that can restrict user permissions, for example, I want a user to have only "SELECT" permissions
>
> Can't do it now, this feature is being planned.
ok
--
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] CrackerSuperior commented on issue #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930754166
> Please provide configuration information: What is the provider type of AUTHORITY in server.yaml?
``` yaml
rules:
- !AUTHORITY
users:
- root@%:root
- sharding@:sharding
provider:
type: ALL_PRIVILEGES_PERMITTED
```
In version 5.0.0-RC1, where should I restrict the databases that users can use?
--
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] CrackerSuperior commented on issue #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930809262
> Do you mean like this? SCHEMA_PRIVILEGES_PERMITTED: #10998
Oh, this is exactly what I need, thanks!
--
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 #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930864517
ShardingSphere is an open community, welcome to improve it together.
--
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 #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930755076
@CrackerSuperior
Change default value `ALL_PRIVILEGES_PERMITTED ` to `NATIVE`.
https://shardingsphere.apache.org/document/current/cn/dev-manual/proxy/
--
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] CrackerSuperior commented on issue #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930758008
> @CrackerSuperior Change default value `ALL_PRIVILEGES_PERMITTED ` to `NATIVE`. https://shardingsphere.apache.org/document/current/cn/dev-manual/proxy/
Okay, so in the "5.0.0-RC1" version, where can I restrict which logic libraries users can use?
--
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 #12838: Does Dist SQL provide statements such as "create user" or "grant permissions"?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12838:
URL: https://github.com/apache/shardingsphere/issues/12838#issuecomment-930759005
Do you mean like this? SCHEMA_PRIVILEGES_PERMITTED:
https://github.com/apache/shardingsphere/pull/10998
--
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