How can to make a new user see table in existing schema I'm new into Oracle so this question might be dumb. I created new user and now I would like him to see table (or even better all tables by one command) in already existing schema (hr schema in this case). Is it even possible? 

From my understanding databases store data and Schemas are equal to Users, so can two users see the same data stored in database, like in my case?
Log in as HR user and run following statement (first replacing the OTHER_USER with actual username):

select 'GRANT SELECT ON ' || table_name || ' TO OTHER_USER;' from user_tables;


then copy the output, paste and execute it as HR user.