RE: Alternatives to REMOTE_OS_AUTHENT?

you then have the username and password hard-coded in the database link definition.....

but something along those lines might work -- if you also set up an account on production that has create session only and is only able to select from the data dictionary for the datafile names. Then create the link with that account....

>From: Jeffery Stevenson <jeff_at_mpv.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Alternatives to REMOTE_OS_AUTHENT?
>Date: Wed, 03 Jan 2001 14:21:47 -0800
>
>Would it be possible to use a database link so you could query the other
>database for the datafile names?
>
>Jeffery Stevenson
>Chief Databeast Tamer
>Medical Present Value, Inc.
>Austin, TX
>
>-----Original Message-----
>Sent: Wednesday, January 03, 2001 3:13 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jeffery Stevenson
> INET: jeff_at_mpv.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).