Alternatives to REMOTE_OS_AUTHENT?

Hi all,

I'm trying to automate a DB copy across our network. Part of this involves logging into the production DB from the test box to get the datafile names.

Without setting REMOTE_OS_AUTHENT in our production DB (huge security hole), does anyone have an idea as to how to accomplish this without hardcoding usernames/passwords and without using an add-on product like Kerberos? e.g. "sqlplus /@PRODDB @get_file_names"

BTW, the databases are 8.0.5 on HPUX. (Can't wait until I can get to 8i!)

TIA,

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA


------------------------------------------------------------------------

This message has been scanned for viruses with Trend Micro's Interscan VirusWall. Received on Wed Jan 03 2001 - 15:11:47 CST