Recent content by 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

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...