create new user

[jmodic]

Tarry, you've missed the point of the question (IMHO). Sure, "GRANT SELECT ANY TABLE" gives him the ability to see any table, but the question was:

Now how Can user ora see all objects (view, table, procedure, package.....)

So the main poit here is on other type of objects, not just tables!

Well, the answer is: Raf, you are wrong. He can't realy use those non-table objects of other users, at least not all type of them. I mean he can't execute their procedures, functions, packages, he can't use their sequences... He can select from their tables and views, he can also use their private synnonym, though - GRANT SELECT ANY TABLE gives him that power.

But if by "how Can user ora see all objects " you mean how can he see all those objects from database dictionary, well, in that case the answer is pretty simple - GRANT_SELECT_CATALOG role enables him to do that, so nothing strange here.