I created a DBLINK from Oracle to Oracle. When I did a describe (DESC) in the Toad editor on a package with a DBLINK, I get the following error
ORA-01031: insufficient privileges
ORA-02063: preceding line from...
Lacking access to back end views like SYS.DBA_SOURCE.
Run a SQL Tracker session to see which back end views or objects Toad might be complaining about and grant the right accordingly.
1. In the Toad main menu, go to Database | Monitor | SQL Tracker
2. At the SQL Tracker window, select "Toad.exe"
3. Click on the green arrow button to start tracking
4. Go back to Toad and make your run to cause the error
5. Go back to SQL Tracker and examine log to see which views or objects Toad is complaining about
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center