In Connect AI, privileges are administrative actions, while permissions are data and execution
access.
- 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.
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 for more information about the scope of these roles.By default, all CData Connect Spreadsheets users have an Administrator role. They have full
Select, Insert, Update, Delete, and Execute permissions.
- A system role (Administrator, Workspace Administrator, Connection Administrator, User Administrator, or Query) defines what a user can do across the platform (managing connections, 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.

- 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
1
In the Roles tab of the Identities page, click Add Role to open the Add Role page.

2
Enter the Role Name.
3
Enter a short description of the role that will appear on the Roles list.
4
In the Entities 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.
5
In the Users tab, click Assign Users to assign multiple users to the same access role.
You can also add permissions to a user on an individual basis. These permissions are added to
the role-based permissions.
6
Select one or more users to assign to the role, and click Confirm.
7
Click Save Changes to save the role.
Edit a Role
You can modify any role or delete an access role at any time by clicking the edit or delete icons in the Roles list.
- Edit the Role Name and Description fields (access roles only).
- Edit the permissions for the role.
- Assign or delete the users assigned to the role.
- Delete the entire role (access roles only).