Roles and permissions

A role is a named set of permissions and table access that you give to users. Use this page to create roles, change what they allow, and retire them safely. Table access and membership have their own page: Manage a role's tables and users.

Open the Roles list

  1. Click Admin in the sidebar.
  2. Choose Profile Management, then Roles.

The list shows each role's Role, Description, Status and Users. Every column sorts and filters; the filter menu has a Reset button, and an empty value shows as (Empty). Click a role to open its details on the right; clicking the selected row again closes the panel. DataMind OS remembers the last role you opened in this browser, and reopens it when you return.

The list also offers a card view, where each role shows Lake: N, DWH: N and Users: N badges.

The row menu offers Edit Role, Edit Permissions, Manage Tables and Delete Role. You see only the actions your permissions allow, and Delete Role is hidden for the built-in Admin role.

The toolbar has Add Role (hover shows Add new role), which appears only if you can create roles, and Audit, which downloads the permission audit as an Excel file. See Permission audit workbook.

You see the Roles tab only if your permissions let you view roles, for example with Roles Viewer. See Permission reference.

Create a role

  1. Click Add Role.
  2. Under Role Details, enter a Role Name of 2 to 50 characters, and optionally a Description of up to 150 characters.
  3. Turn on Active if the role should grant access straight away. The switch starts off, and it is hidden when the name is admin.
  4. Pick a Role Color and a Role Icon. There are 33 icons; a role with no icon shows a Shield.
  5. Click Register. DataMind OS opens the new role and shows "Role registered successfully".

Register stays greyed out until you change the form. An address ending in ?modal=create opens the create form directly.

Registering a role also creates its databases in the data layer: <role>_Lake, <role>_WH and <role>_Temp, and the tokenised PII_ mirrors of its Lake and Warehouse databases. The role's members use them in the Editor and Database Explorer; see SQL dialect and data scope.

Names may use English letters and underscores only, so a name with a hyphen or a digit is refused with "The name field can only contain English letters and underscores". Role names are unique without regard to capitals: a name already in use is refused with "The role with the name X already exists", and a reserved name with "The name is reserved, please choose different one". The name cannot be changed after the role is created.

Edit a role

  1. Open the role.
  2. To change the description, click the pencil beside it, edit the text, then press Enter to save or Escape to cancel.
  3. To change the colour or icon, click the role's icon in its header. In Edit Role Icon, pick a Role Color and a Role Icon, then click Update Icon.
  4. For everything else, choose Edit Role, update the details, and click Update Role. DataMind OS confirms with "Role updated successfully".

Set permissions

  1. In the role panel, click Permissions under Access, or choose Edit Permissions in the row menu.
  2. Pick a category tab, such as Users & Roles or Administration, or type in Search permissions to jump to....
  3. Click a permission tile to grant it. Click it again to remove it. The header shows the total, for example "12 granted".
  4. Click Save changes. DataMind OS confirms with "Role permissions updated successfully". If the save fails, it reports "Failed to save role permissions".

The panel's permissions summary has its own Search permissions... box. An empty list reads "No permissions assigned" with "Nothing has been granted yet.", and a search with no matches reads "No permissions match your search".

To manage roles, a person needs Roles Administrator, or the Standard permissions it bundles, such as Add/Remove Roles, Edit Role Permissions, Edit Role Table Permissions and Manage Role Membership. Roles Viewer gives view-only access. Each part of a role has its own permission, for example Edit Role Icon & Color for the icon and colour and Activate/Deactivate Roles for its status. Holding any one of them unlocks the general Edit Role action, and Manage Role Membership alone covers every action on a role.

For what each permission allows, see Permission reference. For how presets switch on and off in the editor, see How access works.

Change a role's tables and members

A role also decides which Lake and Warehouse tables its members can use, and who holds it. Both editors live on their own page: Manage a role's tables and users. Reach them from Manage Tables in the row menu, or from the role panel's Tables and Assigned users sections. Table access decides which tables a member can use in the Editor; see SQL dialect and data scope.

Deactivate, activate or delete a role

To deactivate or activate a role:

  1. Open the role and find Status.
  2. Click Deactivate role or Activate role.
  3. Confirm the change. DataMind OS asks Confirm Status Change: "Are you sure you want to change the status of this role to Active?" (or Inactive).

A deactivated role stops granting access until you activate it again. Users keep the access of their other active roles. If the change fails, DataMind OS reports "Failed to update role status".

To delete a role:

  1. Remove every user from the role under Users. A role that still has users cannot be deleted, and a role set as the SSO default role cannot be deleted either; set a different default role in Single sign-on (SSO) first.
  2. Choose Delete Role in the row menu, or Delete role in the panel under Status.
  3. In the Delete Role dialog, read the warning and click Delete. DataMind OS confirms with "Role deleted successfully".

The dialog checks the DataPrism semantic models the role owns. If there are any, it warns: "{count} semantic model(s) are owned by this role and will stop working: {names}". If the check cannot run, it reads "Dependants could not be determined because the check failed. Deleting this role may be unsafe."

Warning

Deleting a role is permanent. DataMind OS also deletes the Minds that the role owns, and removes the role from the other Minds and tables that used it; its table access and row-level security are cleared at the same time, and its databases in the data layer are deleted with it.

Settings and defaults

SettingWhat it doesDefault
Role NameIdentifies the role.Required. 2 to 50 characters. Fixed after creation.
DescriptionSays what the role is for.Optional. Up to 150 characters.
ActiveTurns the role's access on or off.Off for a new role.
Role ColorColours the role.Chosen from the colour swatches.
Role IconIcon shown with the role.Shield.

Limits and edge cases

Common refusal messages are explained in Administration troubleshooting.

Questions, answered

Can I rename a role?

No. The name is fixed when the role is created. Create a new role with the right name, move its users to it, then delete the old role.

Why can't I delete this role?

The role still has users, or it is the SSO default role. Remove everyone in its Users section, or set a different default role in Single sign-on (SSO) first.

The delete dialog lists semantic models. What happens if I continue?

The role owns those DataPrism semantic models, so they stop working once it is deleted. Check them first in Concepts and glossary.

What happens to the Minds and tables that used a deleted role?

Deleting a role deletes the Minds that the role owns, and removes the role from the other Minds and tables that used it. Its table access and row-level security are cleared at the same time. Review Minds permissions before you delete.

What happens to users when I deactivate a role?

The role stops granting its permissions to everyone who holds it. Users who have other active roles keep that access. A user whose roles are all inactive cannot sign in until you activate one of them.

Why do I see "The name is reserved, please choose different one"?

The name starts with a prefix that DataMind OS reserves for its own use. Choose a different name.

Can two roles differ only in capital letters?

No. Role names are compared without regard to capitals, so "Finance" and "finance" count as the same name.

I created a role. Why does it grant nothing yet?

New roles start with Active off, so they grant nothing until you switch them on. Open the role, click Activate role, and confirm.

Why does the panel say "Role not found"?

The role was removed while you had it open, or you may not have access to it. The panel shows "Role not found" with "This role may have been removed or you may not have access." Refresh the list and open another role.

Can I change the Admin role, or do I need to set it up?

You do not need to set it up, and you cannot change its permissions. The built-in Admin role always has every permission, so its permissions show as granted and locked. It cannot be deactivated or deleted.