I believe every account in metadata has an authdomain called "DefaulAuth" associated with it. This typically would have the username/password for that particular account (assuming that information has been added to the metadadta, which it is not by default). Then, you can create custom Authdomains, usually on the "Accounts" tab of a metadata group, which have specific usernames/passwords associated with them. Who is able to see/use this authdomain depends on their membership in metadata groups. In your case, if you entered the same username/password for OracleAuth1, OracleAuth2, etc then the same username/password would be submitted to the Oracle database no matter which one you specified. However, the account you're using to register the tables in metadata may not be using using the right one. Did you specify a specific username/password or authdomain for the library connection? This would be on the "Data Server" tab for the library in SMC.
... View more