Add database users
Create database users to provide clients access to the cluster's YugabyteDB database. A database user's access is determined by the roles assigned to the user. YugabyteDB uses role-based access control (RBAC) to manage authorization.
Once you have added them as a user to the database, send them the credentials.
You will also have to authorize their network so that they can access the cluster. Refer to Assign IP allow lists.
Create a database user
When a cluster is added, an admin user is created for the database. You must add additional database users for any other users who require access the cluster database.
To add a database user:
Connect to the cluster using
Add a user using the
yugabyte=# CREATE ROLE <username> WITH LOGIN PASSWORD '<password>';
admin@ycqlsh> CREATE ROLE <username> WITH PASSWORD = '<password>' AND LOGIN = true;
To add or change a password for a user, use the
ALTER ROLE statement.
For more information on managing users in YSQL, refer to Enable users in YSQL.
For more information on managing users in YCQL, refer to Enable users in YCQL.