Delete stub users from an environment

Article
08/27/2024

Stub user records are created as placeholder records in the user table. They're created to allow records to be imported from external systems during migration of those applications. Stub user records are created with a disabled status and assigned with a security role. These users can’t log into the Dataverse environment. For more information, see How stub users are created. You can delete these stub users from the user table.

Delete disabled status stub users

Complete the following steps to turn on the Delete disabled users feature.

Go to the Power Platform admin center.
In the navigation pane, select Environments.
Select a specific environment.
Select Settings > Product > Features.
Scroll through the list and to find the Delete disabled users area.
Set the Enable delete disabled users setting to On.
Select Save.

Soft delete stub users

Soft deleted users remain in the system with a disabled status. Learn more: What happens when a user is soft deleted?

You can manually soft delete a stub user.

Go to the Power Platform admin center.
In the navigation pane, select Environments.
Select a specific environment.
Select Settings > Users + Permissions > Users.
Select Disabled Users from the Filter list.
Enter the stub user in the Search box.
Select the user.
Select the Delete button to delete the user in the environment.

Permanently delete stub users

To permanently delete stub users, the stub users must first be soft deleted. These Prerequisites must be met before a user can be permanently deleted.

To manually permanently delete a stub user, complete the following steps.

Go to the Power Platform admin center.
In the navigation pane, select Environments.
Select a specific environment.
Select Settings > Users + Permissions > Users.
Select Disabled Users from the Filter list.
Enter the stub user in the Search box.
Select the user, and then select Delete Permanently.
Select Delete to delete the user from the environment.

Bulk delete stub users

You can delete multiple stub users using bulk delete. Soft-deleted users remain in the system with a disabled status. Learn more: What happens when a user is soft deleted?

To soft delete stub users in bulk, complete the following steps.

Go to the Power Platform admin center.
In the navigation pane, select Environments.
Select a specific environment.
Select Settings > Users + Permissions > Users.
Select Bulk delete from the command bar.
Select the Stub users option from the Use saved view dropdown list.
Select Next and review the list of records to be soft deleted.

Note

The list of records may contain Microsoft Entra ID users who were permanently deleted from Microsoft Entra ID prior to June 2022. These users can also be deleted as stub users. Select the Back button to return to the query page and modify the filter to change the list of selected users. For example, select + Add row to add an additional filter.
Select Next.
Enter a job name and select a date and time to schedule the deletion system job. Select Next.
Select the email notification checkbox if you want to be notified when a job is completed. Select Next.
Verify the query and the number of records to be deleted, and then select Run bulk delete.

Review the status of bulk delete job

Go to the Power Platform admin center.
In the navigation pane, select Environments.
Select a specific environment.
Select Settings > Audit and logs > System jobs.
Select the bulk delete job and review the results. The results show records in the Successes row that should match the number of records from your previous soft deletion system job. Review a deleted user in the audit log.

If you enabled Dataverse auditing in the environment and in the User table, you can see the list of soft deleted users in the Audit Summary view.

Permanently delete stub users in bulk

To permanently delete stub users, the stub users must first be soft deleted. These Prerequisites must be met before stub users can be permanently deleted.

Go to the Power Platform admin center.
In the navigation pane, select Environments.
Select a specific environment.
Select Settings > Users + Permissions > Users.
Select Bulk delete from the command bar.
Select the Soft Deleted Users view in the Use saved view dropdown list.
Select Next and review the list of records to be permanently deleted.
Select Next again.
Enter a job name and select a date and time to schedule the deletion system job. Select Next.
Select the email notification checkbox if you want to be notified when a job is completed. Select Next.
Verify the query and the number of records to be deleted, and then select Run bulk delete.

Review the job results and verify that all soft deleted stub users were permanently deleted.

Share via