zhangchuangcheng0807 opened a new issue, #19375:
URL: https://github.com/apache/shardingsphere/issues/19375
Problem Description:
1.Hope the proxy account can access all databases in the
shardingsphere-proxy middleware;
2.I hope the app_001 account can only access the app_db_001 database in
the shardingsphere-proxy middleware;
3.I hope the app_002 account can only access the app_db_002 database in
the shardingsphere-proxy middleware;
4.The following configuration can only be used by app_001 and app_002
accounts, and proxy accounts cannot be used. It should be that the users and
provider labels below cover the users and provider labels above.
5.Is there any other way to achieve coexistence of administrator account
and application account?
[root@localhost conf]# pwd
/opt/shardingsphere-proxy-bin-5.1.2/conf
[root@localhost conf]# vim server.yaml
-----------------------------------
rules:
- !AUTHORITY
users:
- proxy@%:passwd
provider:
type: ALL_PERMITTED
users:
- app_001@%:passwd01
- app_002@%:passwd02
provider:
type: DATABASE_PERMITTED
props:
user-database-mappings: app_001@%=app_db_001, app_002@%=app_db_002
--
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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
