Message-Id: <10730.125638@fatcity.com> From: "Mohan, Ross" Date: Wed, 3 Jan 2001 16:59:59 -0500 Subject: OT RE: Alternatives to REMOTE_OS_AUTHENT? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C075D0.83D16740 Content-Type: text/plain; charset="iso-8859-1" Maybe there is a B2B or B2C solution for this? ;-) -----Original Message----- From: Jesse, Rich [mailto:Rich.Jesse@qtiworld.com] Sent: Wednesday, January 03, 2001 4:13 PM To: Multiple recipients of list ORACLE-L Subject: 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@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@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@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). ------_=_NextPart_001_01C075D0.83D16740 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable OT RE: Alternatives to REMOTE_OS_AUTHENT?

Maybe there is a B2B or B2C solution for this? =

;-)

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse@qtiworld.com]
Sent: Wednesday, January 03, 2001 4:13 PM
To: Multiple recipients of list ORACLE-L
Subject: 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           &= nbsp;           &= nbsp;  System/Database Administrator
Rich.Jesse@qtiworld.com      &nbs= p;      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@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@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 =