HOW TO CHECK USER RELATED TABLES

SELECT * FROM CAT;

SELECT * FROM USER_TABLES  WHERE TABLE_NAME LIKE '%my_app_table%';
SELECT * FROM USER_VIEWS WHERE VIEW_NAME LIKE '%my_app_view%';

SELECT * FROM SYS.DBA_TABLES WHERE OWNER='username';
SELECT * FROM SYS.DBA_OBJECTS WHERE OWNER ='owner_name';