SingleStore DB

Adding a User

To add a user, use the GRANT command.

If you have sync_permissions enabled on your cluster, log into the master aggregator as the root user or another user with sufficient permissions, and run:

GRANT <grant_options> TO '<user>'@'<host>' IDENTIFIED BY '<password>'

For example:

GRANT SELECT, INSERT ON db.* TO 'username'@'%' IDENTIFIED BY 'password'

See the GRANT documentation for more details.

Notice

If you do not have sync_permissions enabled, then you must perform the above operations on each aggregator in your cluster.

You can also use Kerberos, SAML, or PAM instead of password-based authentication.