> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/guides/managing-your-organization/managing-logins",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Learn about user permissions and how to add and remove logins in a Firebolt account.

# Manage logins

Logins are managed at the organization level and are used for authentication. Logins are a combination of a login name (email), first name, last name, and password, unless you've configured [Single Sign-On (SSO)](/guides/security/sso). Moreover, logins can be configured with advanced authentication properties such as [MFA](/guides/security/enabling-mfa) and [network policies](/guides/security/network-policies). Logins are linked to users at the account level, so that roles may be managed separately per account. A user must be linked to either a login or a service account for programmatic use to gain access to Firebolt. You can add, edit or delete logins using SQL or in the UI.

To view all logins, click **Configure** to open the configure space, then choose **Logins** from the menu, or query the [information\_schema.logins](/reference-sql/information-schema/logins) view.

<Note>
  Managing logins requires the org\_admin role.
</Note>

## Create a new login

### SQL

To create a login using SQL, use the [CREATE LOGIN](/reference-sql/commands/access-control/create-login) statement. For example:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
CREATE LOGIN "alexs@acme.com" WITH FIRST_NAME = 'Alex' LAST_NAME = 'Summers';
```

### UI

To create a login via the UI:

1. Click **Configure** to open the configure space, then choose **Logins** from the menu:

<img src="https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/loginspage.png?fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=f8fac1059c9f8e2364a0d71e6e82fd25" alt="Configure > Logins" data-og-width="3024" width="3024" data-og-height="510" height="510" data-path="assets/images/loginspage.png" data-optimize="true" data-opv="3" srcset="https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/loginspage.png?w=280&fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=2996377d275aafd8cb9680df58a5f0a0 280w, https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/loginspage.png?w=560&fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=a7ae5312c325b7ee00d9386a69213356 560w, https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/loginspage.png?w=840&fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=b5623d3d6d0a20d4fee01942e3d29069 840w, https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/loginspage.png?w=1100&fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=266872f49bb643f5b453e0c6b98125ea 1100w, https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/loginspage.png?w=1650&fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=9e9a7539bdc2fa80d6b45ea79a37b75a 1650w, https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/loginspage.png?w=2500&fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=ceef954e19e5ffc892b0d241de17d502 2500w" />

2. From the Logins management page, choose **Create Login**.
3. Enter the following details:
   * First name: specifies the first name of the user for the login.
   * Last name: specifies the last name of the user for the login.
   * Login name: specifies the login in the form of an email address. This must be unique within your organization.
4. Optionally, you can:
   * Associate a [network policy](/guides/security/network-policies) with the login by choosing a network policy name under the **Network policy attached** field.
   * Enable password login, which specifies if the login can authenticate Firebolt using a password.
   * Enable multi-factor authentication (MFA). Read more about how to configure MFA [here](/guides/security/enabling-mfa).
   * Set the login as **organisation admin**, which enables fully managing the organization.

## Edit an existing login

### SQL

To edit an existing login using SQL, use the [ALTER LOGIN](/reference-sql/commands/access-control/alter-login) statement. For example:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER LOGIN "alexs@acme.com" SET NETWORK_POLICY = my_network_policy
```

### UI

To edit a login via the UI:

1. Click **Configure** to open the configure space, then choose **Logins** from the menu.

2. Search for the relevant login using the top search filters, or by scrolling through the list of logins. Hover over the right-most column to make the login menu appear, then choose **Edit login details**.
   Edit the desired fields and choose **Save**.

<Note>
  Login name can not be changed for logins that were provisioned via SSO.
</Note>

<img src="https://mintcdn.com/firebolt/vltsHD7UVWpOKjrg/assets/images/editlogin.png?fit=max&auto=format&n=vltsHD7UVWpOKjrg&q=85&s=e73dfc8e1242938d1b7a0e10783549d5" alt="Edit login" style={{"width": "500px"}} width="1406" height="946" data-path="assets/images/editlogin.png" />

## Deleting an existing login

### SQL

To delete an existing login using SQL, use the [DROP LOGIN](/reference-sql/commands/access-control/drop-login) statement. For example:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
DROP LOGIN "alexs@acme.com";
```

### UI

To delete a login via the UI:

1. Click **Configure** to open the configure space, then choose **Logins** from the menu.

2. Search for the relevant login using the top search filters, or by scrolling through the logins list. Hover over the right-most column to make the login menu appear, then choose **Delete login**.

<Note>
  If the login is linked to any users, deletion will not be permitted. The login must be unlinked from all users before deletion.
</Note>
