Oracle - SQL - Table - List all tables current user has access to
SELECT
TABLE_NAME
FROM
all_tables;