Authorization

    ShardingSphere-Proxy uses the global rule, Authority Rule (identified as !AUTHORITY), to configure user and authorization information.

    • : grant all authorities by default without authentication.
    • DATABASE_PERMITTED: grant users the authority to specify a logical database, mapped through user-database-mappings.

    The administrator can choose which authority provider to use as needed when configuring the Authority Rule.

    • The user root can connect to Proxy only through localhost, and the password is root.
    • The provider type is ALL_PERMITTED, which indicates that users are granted all authorities by default without authentication.

    DATABASE_PERMITTED

    The above configuration indicates:

    • The provider type is , which indicates that users are granted database-level authority and configuration is needed.
    • The user root can connect to Proxy only through localhost and can access sharding_db and test_db.
    • The user my_user can connect to Proxy through any host and can access .