I want to fetch the list of tables against each user and owner of different schemas.
I tried this...
Select Owner, Object_Type from all_objects where Object_Type = "Table";
&
Select Owner, Table_Name from all_tables;
But I wanted tables user wise under its Owner.