Unable to view contents of "Material Views" folder

[VTNA_dev]

I have four users with the same version of PL/SQL Developer (7.0.3.1123 09.25249) on their PC two can open and view the contents of the "Materialized Views" folder and two cannot. All four users connect to the same Oracle database with the same ID/Password. This problem only occurs when connected to a production database (higher security). When connected to a development database (less secure) all four users are able to view the contents of the "Materialized views" folder.

 

[Marco Kalter]

Do you see the materialized views when querying the sys.all_objects view in the production database?

 

[truckerlady]

Hey, I'm his co-worker. Yes, the user has access to all_objects and he can see the materialized views. I now no longer can see the materialize views folder after I did an install on a new machine. We can't figure out what is so different about this user and why it no longer works after a new install.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem (open the materialized views folder) and send me the debug.txt file that is generated in the PL/SQL Developer directory.