Configuration – server
ShardingSphere can configure properties related to authority control, the transaction type, and the system configuration, which are all in the server.yaml configuration file.
Authority
ShardingSphere provides control over access to the proxy. Control over the client end's access to the proxy can be achieved through the following YAML configurations:
Table 6.1
Here's an example of the ALL_PRIVILEGES_PERMITTED type:
rules:
- !AUTHORITY
users:
- root@%:root
- sharding@:sharding
provider:
type: ALL_PRIVILEGES_PERMITTED
Here's the code for the SCHEMA_PRIVILEGES_PERMITTED type:
rules:
- !AUTHORITY
users:
- root@:root
...
