User tables
select distinct owner from dba_objects;
If you logged in as Normal User without DBA permission you may uses the following command to see your own schema’s all tables and views.
select * from tab;
it will show all tables in your schema cat synonym of user_catalog
select * from cat;