I have set up a little routine which rebuilds all my remote views programmatically. It works fine, except I have to log on (ORACLE) for each and ever view. This is a pain in the butt. About the only good thing about it is that I will never forget my password.

All the views are SHARE. I tried setting up with SQLCONNECT() at the top, but ORACLE keeps wanting me to log on, and on , and on.

What am I doing wrong ?