Simplest way to log in as Oracle user different from schema user and still see all tables,... of schema?
ALTER SESSION SET CURRENT_SCHEMA 


will work, but you still need to do all of the grants.

–  Phil Oct 29 at 23:33