[GitHub] [shardingsphere] tristaZero opened a new issue #8966: [Enhancement] Authentication feature of ShardingProxy

[GitBox <gi...@apache.org>]

tristaZero opened a new issue #8966:
URL: https://github.com/apache/shardingsphere/issues/8966


   ### Introduction
   
   This feature is the same as the authentication of MySQL or PostgreSQL. ShardingProxy has to do access control when users login in. 
   
   ### Three key points need to clarify
   - This issue is an enhancement feature for the current `Authentication` module
   - All users configured in `server.yaml` of `ShardingProxy` still work and are seen as system users.
   - We will leverage the access-control power of different Databases
   
   ### Tasks
   - ShardingProxy supports `create user` SQL, which will be pushed down to databases
   - ShardingProxy supports `grant` SQL, which will be pushed down to databases
   - Get the `IP` or `hostname` once users login in
   - Get the `user name`, `password` once users login in
   - Get the user privilege information from databases once users login in
   - Transform the  privilege information into the cached `auth` object
   - Compare the authentication from the user-login and database
   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero closed issue #8966: [Enhancement] Authentication feature of ShardingProxy

[GitBox <gi...@apache.org>]

tristaZero closed issue #8966:
URL: https://github.com/apache/shardingsphere/issues/8966


   


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