System Administrators may receive an 'Insufficient Privileges' error when logging in through the standard Salesforce user interface (UI). This occurs when the 'API Only User' permission is enabled on the user's assigned profile or permission set(s). The 'API Only User' permission restricts the user to API access only, preventing normal UI login.
First check to see if there may be another user available in your org with the 'Manage User' permission. If so, that user may navigate to the affected admin user record to identify and review their assigned profile and permission sets to remove or disable any occurrences of the 'API Only User' permission.
If no users are available in your org with the necessary permissions to edit profiles or permission sets it's possible to disable the permission:
For profiles using the API and client tool such as Data Loader:
1. Log in to Data Loader. See Install Data Loader for more details.
Note: You may sign up for a Developer Edition org to download and install Data Loader if you're unable to access or download it from setup in the affected environment.
2. Export the Profile object
3. Locate your assigned profile's row in the export and change the value for the 'PERMISSIONSAPIUSERONLY' column from 'True' to 'False' and save your file.
4. Perform an update to the Profile object using your updated file to update the profile permission.
See also: Insert, Update, or Delete Data Using Data Loader
Note: Using Workbench is recommended here because the tool allows you to perform row level updates directly from query results in the User Interface. This simplifies the process by not requiring you to export and manipulate CSV files. The Data Loader can also still be used to accomplish the same updates.
000384703

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.