# Add a User

To add a user, use the [GRANT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/grant.md) 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:

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

```

For example:

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

```

See the [GRANT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/grant.md) documentation for more details.

> **📝 Note**: 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](https://docs.singlestore.com/db/v9.1/security/authentication/kerberos-authentication.md), [SAML](https://docs.singlestore.com/db/v9.1/security/authentication/saml-authentication.md), or [PAM](https://docs.singlestore.com/db/v9.1/security/authentication/pam-authentication.md) instead of password-based authentication.

***

Modified at: April 3, 2023

Source: [/db/v9.1/security/configure-singlestore-user-accounts/add-a-user/](https://docs.singlestore.com/db/v9.1/security/configure-singlestore-user-accounts/add-a-user/)

(An index of the documentation is available at /llms.txt)