This guide will walk you through how to fix the error "Google Search Console: user permission denied - user X doesn’t have permissions for site".
Permissions
This error means that the user does not meet the data source access requirements, meaning the user role level assigned to the Google Search Console site(s).
To set up the correct access requirements, see this guide: General Data Source Access Requirements.
Re-authenticate
Once the access requirements are correctly set, re-authenticate the data source:
Data Studio: How to re-authenticate a Data Studio connector
Google Sheets: How to re-authenticate a Google Sheets connector
Microsoft Excel: How to re-authenticate an Excel connector
API: How to re-authenticate an API connector
Datawarehouse & Cloud Storage: How to re-authenticate a Datawarehouse and Cloud Storage connector
BigQuery: How to re-authenticate a BigQuery connector
Further assistance
If you continue to have issues after trying the above actions, please submit a request to support with the details of the issue and we will assist you.