In the Object Pallet, I right click on a table and from Action Console, selected ER diagram. Enter the number 1 and clicked OK. It started updating the diagram and then gave this error ora-00942.
I tried with several other tables and got the same error.
Use the SQL Tracker and confirmed that the ER diagram is querying from the Sys.All_Source View for the user environment and user does not have access to select it. Once the DBA granted user access to this View, the user was able to create the ER diagram.
,
The View that is being access can be different from one database to the next so verify what is being query first using SQL Tracker.
Refer to Solution Sol78217 for detail on how to use SQL Tracker:
https://support.quest.com/Search/SolutionDetail.aspx?id=SOL78217
,
,
