I am trying to fix a procedure in one of our applications. In order to fix it properly I need to find the schema owner. The users log in as myapp_unam or perhaps myapp_tst_uname and I need to find the name of the schema owner which could be myapp or myapp_tst or even something else. Since each user owns synonyms to the schema owner I was trying to look at user_synonyms to find the schema owner for the table that I am currently working on. Any help would be appreciated. Thanks.