# Users and databases
Source: https://docs.infraista.com/en/data-storage/databases/users-and-databases



Open the database and select **Users & databases**.

<Shot name="data-storage/databases/users" alt="The Users and databases tab: logical databases on the server and the users with their roles" />

## Users [#users]

Give each app its own user, with only the access it needs.

| Role             | Can do                                                                                                 |
| ---------------- | ------------------------------------------------------------------------------------------------------ |
| **Admin**        | Full control, including creating users and databases with SQL. Created automatically; can't be deleted |
| **Read & write** | Read and change data in every database. Good for apps                                                  |
| **Read-only**    | Only read data. Good for reports and dashboards                                                        |

**Add a user:**

1. Enter a **Username**: 2 to 63 lowercase letters, numbers or underscores, starting with a letter.
2. Pick a **Role**.
3. Select **Add user**.

**Copy the password now**: it isn't shown again.

**Reset password** on a user's row makes a new one (also shown once). **Delete** removes the user, and apps
using it are disconnected.

Users and databases can be changed once the database is running.

## Databases [#databases]

A database server can hold several logical databases. They share the plan's CPU, memory and storage. The
first one is created automatically and marked **Default**.

To add one, enter its name under **Add a database** and select **Add database**. Users get their usual
access to it. You can also create a database from the **Data Explorer** (**New database**).

**Delete database** on a row deletes that database and all its tables. This can't be undone.

## Related [#related]

* [Connect to a database](/en/data-storage/databases/connect-to-a-database)