> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-trino-dialect.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Configuring SQL console role assignments

> Guide showing how to manage SQL console role assignments

export const Image = ({img, alt, size = "lg", background}) => {
  const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
  const backgroundColor = background === "white" ? "white" : background === "black" ? "rgb(31 31 28)" : undefined;
  return <div className={`ch-image-${normalizedSize}`}>
      <Frame>
        <img src={img} alt={alt} style={{
    backgroundColor
  }} />
      </Frame>
    </div>;
};

<Warning>
  This setting is deprecated and has been replaced with a new setting on the role creation screen in organizations that have migrated to custom roles. For more information, see [Manage cloud users](/products/cloud/guides/security/cloud-access-management/manage-cloud-users).
</Warning>

This guide shows you how to configure SQL console role assignments, which determine console-wide access permissions and the features that a user can access within Cloud console. To customize database permissions for an individual SQL console user, see [SQL console users and roles](/products/cloud/guides/security/cloud-access-management/manage-database-users#sql-console-users-and-roles).

<Steps>
  <Step title="Access service settings" id="access-service-settings">
    From the services page, click the menu in the top right corner of the service for which you want to adjust SQL console access settings.

    <Image img="https://mintcdn.com/private-7c7dfe99-trino-dialect/hSTh3vuXNyP5AEx2/images/cloud/guides/sql_console/service_level_access/1_service_settings.webp?fit=max&auto=format&n=hSTh3vuXNyP5AEx2&q=85&s=89d75cb9961033bbaa4e660e1fe1dad0" size="lg" width="4032" height="876" data-path="images/cloud/guides/sql_console/service_level_access/1_service_settings.webp" />

    Select `settings` from the popup menu.

    <Image img="https://mintcdn.com/private-7c7dfe99-trino-dialect/hSTh3vuXNyP5AEx2/images/cloud/guides/sql_console/service_level_access/2_service_settings.webp?fit=max&auto=format&n=hSTh3vuXNyP5AEx2&q=85&s=132468bf21056f4030cefb93b7243a1e" size="lg" width="2600" height="1060" data-path="images/cloud/guides/sql_console/service_level_access/2_service_settings.webp" />
  </Step>

  <Step title="Adjust SQL console access" id="adjust-sql-console-access">
    Under the "Security" section, find the "SQL console access" area:

    <Image img="https://mintcdn.com/private-7c7dfe99-trino-dialect/hSTh3vuXNyP5AEx2/images/cloud/guides/sql_console/service_level_access/3_service_settings.webp?fit=max&auto=format&n=hSTh3vuXNyP5AEx2&q=85&s=4c50341608e0bf8bb22f908e72dd8e22" size="md" width="2304" height="620" data-path="images/cloud/guides/sql_console/service_level_access/3_service_settings.webp" />
  </Step>

  <Step title="Update the settings for Service Admin" id="update-settings-for-service-admin">
    Select the drop-down menu for Service Admin to change the access control settings for Service Admin roles:

    <Image img="https://mintcdn.com/private-7c7dfe99-trino-dialect/hSTh3vuXNyP5AEx2/images/cloud/guides/sql_console/service_level_access/4_service_settings.webp?fit=max&auto=format&n=hSTh3vuXNyP5AEx2&q=85&s=7a33edab2d56b6f19c60a529cbccd237" size="md" width="2304" height="620" data-path="images/cloud/guides/sql_console/service_level_access/4_service_settings.webp" />

    You can choose from the following roles:

    | Role          |
    | ------------- |
    | `No access`   |
    | `Read only`   |
    | `Full access` |
  </Step>

  <Step title="Update the settings for Service Read Only" id="update-settings-for-service-read-only">
    Select the drop-down menu for Service Read Only to change the access control settings for Service Read Only roles:

    <Image img="https://mintcdn.com/private-7c7dfe99-trino-dialect/hSTh3vuXNyP5AEx2/images/cloud/guides/sql_console/service_level_access/5_service_settings.webp?fit=max&auto=format&n=hSTh3vuXNyP5AEx2&q=85&s=6b67f80eb34ccae5986fff163bd41c22" size="md" width="2304" height="620" data-path="images/cloud/guides/sql_console/service_level_access/5_service_settings.webp" />

    You can choose from the following roles:

    | Role          |
    | ------------- |
    | `No access`   |
    | `Read only`   |
    | `Full access` |
  </Step>

  <Step title="Review users with access" id="review-users-with-access">
    An overview of users for the service can be viewed by selecting the user count:

    <Image img="https://mintcdn.com/private-7c7dfe99-trino-dialect/hSTh3vuXNyP5AEx2/images/cloud/guides/sql_console/service_level_access/6_service_settings.webp?fit=max&auto=format&n=hSTh3vuXNyP5AEx2&q=85&s=cc969545e0bfd5d8707374a7ac4b3754" size="md" width="2304" height="620" data-path="images/cloud/guides/sql_console/service_level_access/6_service_settings.webp" />

    A tab will open to the right of the page showing the total number of users and their roles:

    <Image img="https://mintcdn.com/private-7c7dfe99-trino-dialect/hSTh3vuXNyP5AEx2/images/cloud/guides/sql_console/service_level_access/7_service_settings.webp?fit=max&auto=format&n=hSTh3vuXNyP5AEx2&q=85&s=410580741a12e1b8f4ba14ef0cb18170" size="md" width="4040" height="2338" data-path="images/cloud/guides/sql_console/service_level_access/7_service_settings.webp" />
  </Step>
</Steps>
