You can query the all_tables view - there is an owner field in that view.