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

# Roles

> The **Roles** tab on the ***Roles & Policies*** page enables you to manage system roles and access roles on your Connect AI account.

A **Role** defines the user's privileges and permissions.

> [!NOTE]
>
> In Connect AI, privileges are administrative actions, while permissions are data and execution
> access. Access roles are being replaced by [policies](https://docs.cloud.cdata.com/en/Roles-Policies/Policies.md), which are now the recommended way to grant permissions to data. You can assign policies to users, system roles, and SCIM groups (if SCIM groups are provisioned).

The following system roles are available:

* **Administrator** has full access to all Connect AI functions, including adding and managing users.
* **Workspace Administrator** has full control within their assigned workspaces, including the privileges of a Connection Administrator. They manage workspace membership, the LLM and MCP Gateways, and context for those workspaces. Workspace Administrators do not see the **Identities** page.
* **Connection Administrator** manages connections, virtual schemas, jobs, the data warehouse, and global context; also assigns connection and virtual schema permissions.
* **User Administrator** manages users within their assigned workspaces. They can also add users to and remove users from those workspaces.
* **Query** users can authenticate to a connection with their own credentials, as long as the user and connection meet the following criteria:

  * An Administrator, Workspace Administrator, or Connection Administrator grants the user permission to use the connection.
  * An Administrator selects **Per-User Authentication**, rather than **Shared Authentication**, for the connection.

  A **Query** user can also issue queries to connections they have access to through the [Data Explorer](https://docs.cloud.cdata.com/en/Data-Explorer.md) page and through [integration tools](https://docs.cloud.cdata.com/en/Integrations.md). This role also allows viewing personal query logs.

Only the Administrator role applies to the entire account. All other system roles, including User Administrator, are limited to a workspace: a user with one of these roles has that role's access only within the workspaces they are assigned to. The same user can have a different system role, and different access roles, in each workspace they belong to. See [System Roles Matrix](https://docs.cloud.cdata.com/en/Permissions.md#system-roles-matrix) for a complete breakdown of what each system role can do.

Every account must have at least one active Administrator.

## Role Assignment

The following rules determine who can assign each system role:

* Only an **Administrator** can assign the **Administrator** role.
* An **Administrator** can assign the **Workspace Administrator**, **Connection Administrator**, and **Query** roles.
* A **Workspace Administrator** can assign only the **Connection Administrator** and **Query** roles, and only within their own workspaces.
* An **Administrator** or **User Administrator** can assign the **User Administrator** and **Query** roles, and a User Administrator can do so only within their own workspaces and only for users who currently hold the Query or User Administrator role.

## Workspace Membership

An **Administrator**, **Workspace Administrator**, or **User Administrator** can add users to or remove users from a workspace. A Workspace Administrator or User Administrator can do so only in workspaces where they hold the role.

See [Permissions and Access Control](https://docs.cloud.cdata.com/en/Permissions.md) for more information about the scope of these roles.

> [!NOTE]
>
> By default, all CData Connect Spreadsheets users have an Administrator role. They have full
> Select, Insert, Update, Delete, and Execute permissions.

The **Roles** tab contains information about every role in Connect AI. Roles consist of predefined **system roles** and **access roles**:

* A **system role** (Administrator, Workspace Administrator, Connection Administrator, User Administrator, or Query) defines what a user can do across the platform (managing connections, managing users, and running queries), and every user has exactly one.
* An **access role** is an optional, admin-defined set of data and virtual schema permissions assigned on top of the system role; access roles are additive, so a user can hold several.

![Roles list](https://mintcdn.com/cdata/jeBdFSJlMEzZ01Mi/en/images/roles.png?fit=max\&auto=format\&n=jeBdFSJlMEzZ01Mi\&q=85\&s=0dec77e0e4d779a857321f9f2956008f)

It contains the following information:

* A search bar to search for a role.
* A row for every role in your account:
  * **Role** is the role name.
  * **Privileges & Permissions** is a short overview of the scope of the role.
  * Edit and delete icons for the role. System roles cannot be deleted.

## Add an Access Role

> [!NOTE]
>
> Access roles are being replaced by [policies](https://docs.cloud.cdata.com/en/Roles-Policies/Policies.md), which are now the recommended way to grant permissions to data.

**Step 1**

In the **Roles** tab of the **Roles & Policies** page, click **Add Role** to open the **Add
Role** page.

![Add a Role](https://mintcdn.com/cdata/oDRByaRQbRhQK938/en/images/add_role.png?fit=max\&auto=format\&n=oDRByaRQbRhQK938\&q=85\&s=d89bbf603111039473b7dcf136a5292a)

**Step 2**

Enter the **Role Name**.

**Step 3**

Enter a short description of the role that appears on the **Roles** list.

**Step 4**

If you have more than one workspace, select the workspace in which to add the role.

**Step 5**

Now assign permissions in the workspace (for example, **General**). In the **Access** tab,
select the appropriate permissions for entities (data connections and virtual schemas) in your
Connect AI instance. For more information about permissions, see [Permissions and Access
Control](https://docs.cloud.cdata.com/en/Permissions.md).

**Step 6**

In the **Users** tab, click **+ Assign Users** to assign multiple users to the same access
role.

> [!NOTE]
>
> You can also add permissions to a user on an individual basis. These permissions are added to
> the role-based permissions.

**Step 7**

Select one or more users to assign to the role, and click **Confirm**.

**Step 8**

In the **Service Accounts** tab, click **+ Assign Service Accounts** to assign multiple service
accounts to the same access role.

**Step 9**

Click **Save Changes** to save the role.

## Edit a Role

You can modify a role at any time by clicking its edit icon in the **Roles** list. You can delete an access role by clicking its delete icon.

![Edit a Role](https://mintcdn.com/cdata/j43IEEL3kb81YrLY/en/images/edit_role.png?fit=max\&auto=format\&n=j43IEEL3kb81YrLY\&q=85\&s=02155932fd44f1adf40c3d1cd9a6cc66)

In the **Edit Role** page, you can do the following:

* Edit the **Role Name** and **Description** fields (access roles only).
* Edit the permissions for the role (access roles only).
* Assign users to or remove users from the role.
* Assign service accounts to or remove service accounts from the role (access roles only).
* Delete the entire role (access roles only).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.