That's strange, Can this same user see all of these objects when connected through sql*plus.
Once you have eliminated all of the impossible, whatever remains however improbable, must be true.
Forum Rules