Configuring SingleStoreDB user accounts


By default, user accounts are configured independently on each SingleStoreDB aggregator node. Whenever you add a new aggregator node, you will also need to configure user accounts on it. Users do not normally connect to leaves, so it is generally not necessary to configure user accounts on leaf nodes. Only the root user is required on leaf nodes.

Also, you can automatically synchronize non-root user accounts across your cluster to avoid manually managing these accounts on each aggregator node. See Synchronizing Permissions Across Your Cluster for more details on how to enable this functionality.