- Administrators have full access to all Connect AI functions, including adding and managing users.
- Connection Administrators can create, edit, and delete connections and workspaces. They can also view users, query all connections, and view connection-related audit log events.
- User Administrators can create, invite, edit, and disable users, assign and revoke roles, and view user-related audit events.
-
Query users can authenticate to a connection with their own credentials, as long as the user and connection meet the following criteria:
- The Administrator grants the user permission to use the connection.
- The Administrator selects Per-User Authentication, rather than Shared Authentication, for the connection.
By default, all CData Connect Spreadsheets users have an Administrator role. They have full Select, Insert, Update, Delete, and Execute permissions.
Users
The Users tab contains information about every user in Connect AI.
- The number of user seats that are available on your account.
- A row for every user on your account:
- User displays the email address that is associated with the user.
- Role indicates the user’s role.
- Status shows the state of the user’s account (Active, Inactive, or Invited).
- Edit and delete icons for the user. If the user’s status is Invited, there is also a resend icon to resend the user’s invitation.
Invite Users
To add users to your Connect AI account, follow these steps:Enter the email address of the user that you want to invite. To send multiple invitations at the same time, add a space between each email address.

If you invite multiple users at the same time, they will have the same role(s) and permissions. You can change their role(s) and permissions individually after sending the invitation.
(Query users only) Toggle on Support Access Privileges if you want the user(s) to be able to authorize support access to their account. Administrators can revoke support access at any time.
(Optional) Select Permissions for the new user(s). Select the allowed permissions for each entity (data connection or workspace) in the system. Administrators and User Administrators can edit permissions later.For more information about permissions, see Permissions and Access Control.
Accept an Invitation
Follow these steps to set up access after receiving an invitation email:Create a password that meets the provided criteria. After you create a password, the login page appears.
Connect AI supports Single Sign-On (SSO) through popular SSO providers. If SSO is enabled on your account, the invitation flow uses your SSO provider instead of the manual password process.
Manage Invitations
If a user has a pending invitation that they have not accepted, their status displays as Invited. Click a pending user to view and manage their invitation. On this page, you can view the pending user’s email address, the expiration time for the invitation, and the invite code. You can also manage the user’s invitation, as follows:- To revoke the invitation and delete the user, click Delete User.
- To resend the invitation email to the entered email address, click Resend Invite.
Edit Users
Click a user in the list (or click the Edit button) to open the Edit User page.
- Editable First Name and Last Name fields.
- A non-editable Email field.
- A drop-down menu to select the user’s System Role.
- A drop-down menu to select an additional Access Role (optional). These are any custom roles that were created.
- A toggle for enabling or disabling Support Access Privileges (query users only). If enabled, the query user can grant account access to the CData support team.
- Check boxes for toggling the user’s permissions for each data source. (Note that CData Connect Spreadsheets users do not have a permissions section, because they have full permissions.)
Delete Users
To delete the user, click Delete User.If the user is the last remaining Administrator on your account, they cannot be deleted.
Roles
The Roles tab contains information about every role in Connect AI. Roles consist of predefined platform roles and custom roles.
- 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. Platform roles cannot be deleted.
Add a Custom Role
In the Entities tab, select the appropriate permissions for entities (data connections and workspaces) in your Connect AI instance. For more information about permissions, see Permissions and Access Control.
In the Users tab, click Assign Users to assign multiple users to the same custom role.
You can also add permissions to a user on an individual basis. These permissions are added to the role-based permissions.
Edit a Role
You can modify any role or delete a custom role at any time by clicking the edit or delete icons in the Roles list.
- Edit the Role Name and Description fields (custom roles only).
- Edit the permissions for the role.
- Assign or delete the users assigned to the role.
- Delete the entire role (custom roles only).

