Problem expanding/viewing Materialized Views

[Bob E]

We are currently using PL/SQL Developer version 9.0.1.1613. One of our testers needed access to all the materialized views. I created a role for him and granted SELECT on all the MVs to that role.

He has and All objects for his filter. However, selecting Materialized Views shows nothing. He can see the underlying tables for the MVs but nothing in the MV selection itself.

I know his privs are fine in the database because running this query: select * from all_mviews shows all the MVs in question.

Any suggestions would be most appreciated.

Thanks.

Bob

 

[mike]

Just a guess, but have you tried toggling the "Use DBA Views if available" preference? It's listed under the options category in the preference screen.

 

[Bob E]

Thanks. Yes, I had seen that suggestion in an older post and tried it but that didn't solve the "problem."

If he uses TOAD to test this then he sees all the MVs. Also, if I grant him select any table then it shows up but of course that's overkill on privs.

Bob