Simple Selects in Oracle

From Initq

• List all tables a user has access to

SELECT table_name FROM all_tables;