Add a User
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
To add a user, use the GRANT command.
If you have sync_
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.
Note
If you do not have sync_
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.
Last modified: April 3, 2023