Console access: Has access to all Materialize console features, including administrative features (e.g., invite users, create service accounts, manage billing, and organization settings).
Database access: Has
Console access: Has no access to Materialize console administrative features.
Database access: Inherits role-level privileges defined by the PUBLIC role; may also have additional privileges via grants or default privileges. See Access control control.
Console access: Has access to all Materialize console features, including administrative features (e.g., invite users, create service accounts, manage billing, and organization settings).
Database access: Has
Console access: Has no access to Materialize console administrative features.
Database access: Inherits role-level privileges defined by the PUBLIC role; may also have additional privileges via grants or default privileges. See Access control control.
Select the organization role:
| Organization role | Description |
|---|---|
| Organization Admin |
|
| Organization Member |
|
| 1. Click **Create Password** to generate a new password for your service account. 1. Store the new password securely. > **Note:** Do not reload or navigate away from the screen before storing the > password. This information is not displayed again. 1. Connect with the new service account to finish creating the new account. > **Note:** - The new account creation is not finished until the first time you connect with > the account. > - The first time the account connects, a database role with the same name as the > specified service account **User** is created, and the service account creation is complete. 1. Find your new service account in the **App Passwords** table. 1. Click on the **Connect** button to get details on connecting with the new account. **psql:** If you have `psql` installed: 1. Click on the **Terminal** tab. 1. From a terminal, connect using the psql command displayed. 1. When prompted for the password, enter the app's password. The first time the account connects, a database role with the same name as the specified service account **User** is created, and the service account creation is complete. **Other clients:** To use a different client to connect, 1. Click on the **External tools** tab to get the connection details. 1. Update the client to use these details and connect. The first time the account connects, a database role with the same name as the specified service account **User** is created, and the service account creation is complete. ## Terraform **Minimum requirements:** `terraform-provider-materialize` v0.8.1+ 1. Create a new service user using the [`materialize_role`](https://registry.terraform.io/providers/MaterializeInc/materialize/latest/docs/resources/role) resource: ```hcl resource "materialize_role" "production_dashboard" { name = "svc_production_dashboard" region = "aws/us-east-1" } ``` 1. Create a new `service` app password using the [`materialize_app_password`](https://registry.terraform.io/providers/MaterializeInc/materialize/latest/docs/resources/app_password) resource, and associate it with the service user created in the previous step: ```hcl resource "materialize_app_password" "production_dashboard" { name = "production_dashboard_app_password" type = "service" user = materialize_role.production_dashboard.name roles = ["Member"] } ``` 1. Optionally, associate the new service user with existing roles to grant it existing database privileges. ```hcl resource "materialize_database_grant" "database_usage" { role_name = materialize_role.production_dashboard.name privilege = "USAGE" database_name = "production_analytics" region = "aws/us-east-1" } ``` 1. Export the user and password for use in the external application or service. ```hcl output "production_dashboard_user" { value = materialize_role.production_dashboard.name } output "production_dashboard_password" { value = materialize_app_password.production_dashboard.password } ``` For general guidance on using the Materialize Terraform provider to manage resources in your region, see the [reference documentation](/manage/terraform/). ## Next steps The organization role for a user/service account determines the default level of database access. Once the account creation is complete, you can use [role-based access control (RBAC)](/security/cloud/access-control/#role-based-access-control-rbac) to control access for that account. --- ## Invite users > **Note:** - Until the user accepts the invitation and logs in, the user is listed as > **Pending Approval**. > - When the user accepts the invitation, the user can set the user password and > log in to activate their account. The first time the user logs in, a database > role with the same name as their e-mail address is created, and the account > creation is complete. As an **Organization administrator**, you can invite new users via the Materialize Console. 1. [Log in to the Materialize Console](/console/). 1. Navigate to **Account** > **Account Settings** > **Users**. 1. Click **Invite User** and fill in the user information. 1. In the **Select Role**, select the organization role for the user: | Organization role | Description | | --- | --- | | Organization Admin |Note: - The first user for an organization is automatically assigned the Organization Admin role.
- An Organization Admin has
superuser privileges in the database. Following the principle of least privilege, only assign Organization Admin role to those users who require superuser privileges.- Users/service accounts can be granted additional database roles and privileges as needed.
Console access: Has access to all Materialize console features, including administrative features (e.g., invite users, create service accounts, manage billing, and organization settings).
Database access: Has
Console access: Has no access to Materialize console administrative features.
Database access: Inherits role-level privileges defined by the PUBLIC role; may also have additional privileges via grants or default privileges. See Access control control.