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/10/08 02:42:19 UTC

[GitHub] [shardingsphere] CrackerSuperior commented on pull request #10998: custom authority，schema can be assigned to proxy users

CrackerSuperior commented on pull request #10998:
URL: https://github.com/apache/shardingsphere/pull/10998#issuecomment-938293720


   > authority enhance，sample：
   > 
   > ```
   > - !AUTHORITY
   >   users:
   >     - root@:root
   >     - user1@:user1
   >     - user1@127.0.0.1:user1
   >   provider:
   >     type: SCHEMA_PRIVILEGES_PERMITTED
   >     props:
   >       user-schema-mappings: root@=test, user1@127.0.0.1=db_dal_admin, user1@=test, user1@=db_dal_admin
   > ```
   > 
   > when using root login from any host，you can use database test. when using user1 login from 127.0.0.1，you can use database db_dal_admin. when using user1 login from any other host，you can use database test and db_dal_admin.
   
   So, what if I want user1 to be able to use all the libraries?


-- 
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