@AcharkiMed - Thanks for responding to the post.   To explain long story short... We are using MicroStrategy Reporting tool with Apache Impala which creates tables while running the reports. Some times if the report fails the drop tables doestnt get executed and it results in junk tables in impala and they never get dropped unless we explicitly drop them.   So I wanted to list out the tables which are created by a db login so that I can go ahead drop all the tables which are created by a seperate login.   Let me know if you need more info.     ... View more