Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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_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).
------_=_NextPart_001_01C075D0.83D16740
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Diso-8859-1">
<TITLE>OT RE: Alternatives to REMOTE_OS_AUTHENT?</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Maybe there is a B2B or B2C solution for this? =</FONT>
<P><FONT SIZE=3D2>;-)</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Jesse, Rich [<A = HREF=3D"mailto:Rich.Jesse_at_qtiworld.com">mailto:Rich.Jesse_at_qtiworld.com</= A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, January 03, 2001 4:13 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Alternatives to REMOTE_OS_AUTHENT?</FONT> </P> <BR>
<P><FONT SIZE=3D2>Hi all,</FONT>
</P>
<P><FONT SIZE=3D2>I'm trying to automate a DB copy across our =
network. Part of this involves</FONT>
<BR><FONT SIZE=3D2>logging into the production DB from the test box to =
get the datafile names.</FONT>
</P>
<P><FONT SIZE=3D2>Without setting REMOTE_OS_AUTHENT in our production =
DB (huge security hole),</FONT>
<BR><FONT SIZE=3D2>does anyone have an idea as to how to accomplish =
this without hardcoding</FONT>
<BR><FONT SIZE=3D2>usernames/passwords and without using an add-on =
product like Kerberos? e.g.</FONT>
<BR><FONT SIZE=3D2>"sqlplus /@PRODDB @get_file_names"</FONT>
</P>
<P><FONT SIZE=3D2>BTW, the databases are 8.0.5 on HPUX. (Can't =
wait until I can get to 8i!)</FONT>
</P>
<P><FONT SIZE=3D2>TIA,</FONT>
<BR><FONT SIZE=3D2>Rich =
Jesse &= nbsp; &= nbsp; System/Database Administrator</FONT><BR><FONT =
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=---------</FONT>
<P><FONT SIZE=3D2>This message has been scanned for viruses with Trend =
Micro's Interscan VirusWall.</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Jesse, Rich</FONT> <BR><FONT SIZE=3D2> INET: Rich.Jesse_at_qtiworld.com</FONT> </P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=-----</FONT>
![]() |
![]() |