Hi,
I've create a new user: (oracle 8.1.7.0 O.S. win 2000)
connect system/manager@dboracle
create user ora
identified by tree
default tablespace
temporary tablespace temp;
grant connect, resource to ora;
grant select any table to ora;
grant select_catalog_role to ora;
grant create public synonym to ora;
Now how Can user ora see all objects (view, table, procedure, package.....) of user ora1??
regards
Raf