The following table lists required permissions for data restore.
Required Roles and Permissions
Restore to on-premises Microsoft SharePoint
To restore data to on-premises SharePoint, make sure to configure user accounts as follows:
The account must be granted Full Control to connect to the target SharePoint server.
The account must be assigned either the Site Administrator or System Account role to restore user permissions.
If permissions of items being restored are inherited from the parent one, the account must be granted Full Control.
If permissions of items being restored are not inherited from the parent one and items being restored replace the existing ones, the account must be granted Contribute and Full Control.
Restore to Microsoft Office 365
To restore data to SharePoint Online, the user account must have the SharePoint Administrator role.
Consider the following:
For restore of personal SharePoint sites using the modern authentication method, make sure to select the Allow users to run custom script on personal sites option in the SharePoint admin center. For more information, see this Microsoft article.