Return
-
Title
Accessing any tab in the Schema Browser gave "ORA-01031: insufficient privileges" error. -
Description
When accessing any tab in the Schema Browser (Tables, Procedures, Views, etc.), Toad throws the following error:
ORA-01031: insufficient privileges
-
Cause
The login schema probably do not have certain rights to the backend SYS views that Toad needs.
-
Resolution
Run a SQL Tracker session to see which SYS View the login schema needs to be granted rights to.
a. In the Toad main menu, go to Database | Monitor | SQL Tracker.
b. At the SQL Tracker window, select "Toad.exe".
c. Click on the green arrow button to start tracking.
d. Go back to Toad and make your run to cause the issue.
e. Go back to SQL Tracker to get what Toad captured and grant the appropriate rights.