Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: password for internal

RE: password for internal

From: Javier Morales <Javier_at_infojobs.net>
Date: Thu, 2 Nov 2000 13:29:22 +0100
Message-Id: <10668.120948@fatcity.com>


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_01C044C9.6D01FBC0
Content-Type: text/plain;

        charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

internal allways have a password that's ORACLE if you connect to oracle in the host machine, server manager doesn't = ask for
password...
=20

you also can change internal's password with ALTER USER internal = IDENTIFIED
BY new_password.
=20

I hope this would help.
=20

 ---------------------------------------=20
 Javier Morales - javier_at_infojobs.net=20  Administraci=F3n Bases de Datos Oracle - InfoJobs.net=20  Tel. +34 902 10 60 90 Ext. 2067=20
 Fax. +34 (93) 580 56 60=20
 =20

-----Mensaje original-----
De: Sonja =A9ehovic [mailto:sonja.sehovic_at_zg.tel.hr] Enviado el: jueves 2 de noviembre de 2000 13:06 Para: Multiple recipients of list ORACLE-L Asunto: Re: password for internal

Initialy, I don't have password for INTERNAL, but for the security = reasons I
want to put it. =20
Thanks for the tip. I'll try to run the script you mentioned.
=20

Sonja

Sent: Thursday, November 02, 2000 10:51 AM Subject: RE: password for internal

Internal has a password, of course, but if you're connecting in the = host,
you will not need password in the default setup.
=20

You mustn't allow connections in the host (in UNIX, you can control the access to Oracle user...) but if you can't, you would probably will = have to
enable password policies running the script =20
=20

utlpwdmg.sql
in the folder rdbms/admin/
=20

then you would be able to set up resource limits to system parameters, management password lifes, etc.
=20
=20
=20

Hope this would help...
... but the most important is not allowing connections to server = manager in
host...
=20

 ---------------------------------------=20
 Javier Morales - javier_at_infojobs.net=20  Administraci=F3n Bases de Datos Oracle - InfoJobs.net=20  Tel. +34 902 10 60 90 Ext. 2067=20
 Fax. +34 (93) 580 56 60=20
 =20

-----Mensaje original-----
De: Sonja =A9ehovic [mailto:sonja.sehovic_at_zg.tel.hr] Enviado el: jueves 2 de noviembre de 2000 9:41 Para: Multiple recipients of list ORACLE-L Asunto: password for internal

Hi listers!
I want to put a password on INTERNAL. I tried with ORAPWD but it didn't work.=20
It is Oracle 8.1.5 on AIX.
Any ideas, suggestions?
Thanks,

    Sonja
=20

------_=_NextPart_001_01C044C9.6D01FBC0
Content-Type: text/html;

        charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-2">
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D474453112-02112000>internal allways have a password = that's&nbsp;=20
ORACLE</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN = class=3D474453112-02112000>if=20
you connect to oracle in the host machine, server manager doesn't ask = for=20
password...</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20 class=3D474453112-02112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN = class=3D474453112-02112000>you=20
also can change internal's password with ALTER USER internal IDENTIFIED = BY=20
new_password.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20 class=3D474453112-02112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN = class=3D474453112-02112000>I=20
hope this would help.</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20 class=3D474453112-02112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN = class=3D474453112-02112000>
<P><FONT face=3DVerdana=20
size=3D2>&nbsp;---------------------------------------</FONT> <BR><FONT =

face=3DVerdana size=3D2>&nbsp;Javier Morales&nbsp; - = javier_at_infojobs.net</FONT>=20
<BR><FONT face=3DVerdana size=3D2>&nbsp;Administraci=F3n Bases de Datos = Oracle -=20
InfoJobs.net</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;Tel. = +34&nbsp;</FONT>=20
<FONT face=3DVerdana size=3D2>902 10 60 90</FONT><FONT face=3DVerdana = size=3D2>&nbsp;=20
Ext. 2067</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;Fax. +34 (93) = 580 56=20
60</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;</FONT>=20 </P><BR></SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">   <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Mensaje original-----<BR><B>De:</B> Sonja =A9ehovic=20   [mailto:sonja.sehovic_at_zg.tel.hr]<BR><B>Enviado el:</B> jueves 2 de = noviembre=20
  de 2000 13:06<BR><B>Para:</B> Multiple recipients of list=20   ORACLE-L<BR><B>Asunto:</B> Re: password for = internal<BR><BR></DIV></FONT>
  <DIV><FONT face=3D"Arial CE" size=3D2>Initialy, I don't have password = for=20
  INTERNAL, but for the security reasons I want to put it.&nbsp; = </FONT></DIV>
  <DIV><FONT face=3D"Arial CE" size=3D2>Thanks for the tip. I'll try to = run the=20
  script you mentioned.</FONT></DIV>

  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3D"Arial CE" size=3D2>Sonja</FONT></DIV>
  <BLOCKQUOTE=20

  style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; = MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

    <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>     <DIV=20
    style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20

    <A href=3D"mailto:Javier_at_infojobs.net" = title=3DJavier_at_infojobs.net>Javier=20

    Morales</A> </DIV>
    <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20     href=3D"mailto:ORACLE-L_at_fatcity.com" = title=3DORACLE-L_at_fatcity.com>Multiple=20

    recipients of list ORACLE-L</A> </DIV>     <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, November 02, = 2000 10:51=20

    AM</DIV>
    <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: password for=20 internal</DIV>

    <DIV><BR></DIV>
    <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000>Internal has a password, of course, but = if you're=20

    connecting in the host, you will not need password in the default=20     setup.</SPAN></FONT></DIV>
    <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000>You mustn't allow connections in the = host (in UNIX,=20

    you can control the access to Oracle user...) but if you can't, you = would=20

    probably will have to enable password policies running the=20     script&nbsp;&nbsp; </SPAN></FONT></DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000>utlpwdmg.sql</SPAN></FONT></DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000>in the folder = rdbms/admin/</SPAN></FONT></DIV>

    <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000>then you would be able to set up = resource limits to=20

    system parameters, management password lifes, = etc.</SPAN></FONT></DIV>

    <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000>Hope this would = help...</SPAN></FONT></DIV>

    <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000>... but the most important is not = allowing=20

    connections to server manager in host...</SPAN></FONT></DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20     class=3D245552409-02112000></SPAN></FONT>&nbsp;</DIV>     <DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN = class=3D245552409-02112000>

    <P><FONT face=3DVerdana=20

    size=3D2>&nbsp;---------------------------------------</FONT> =
<BR><FONT=20

    face=3DVerdana size=3D2>&nbsp;Javier Morales&nbsp; - = javier_at_infojobs.net</FONT>=20

    <BR><FONT face=3DVerdana size=3D2>&nbsp;Administraci=F3n Bases de = Datos Oracle -=20

    InfoJobs.net</FONT> <BR><FONT face=3DVerdana size=3D2>&nbsp;Tel.=20     +34&nbsp;</FONT> <FONT face=3DVerdana size=3D2>902 10 60 = 90</FONT><FONT=20

    face=3DVerdana size=3D2>&nbsp; Ext. 2067</FONT> <BR><FONT = face=3DVerdana=20

    size=3D2>&nbsp;Fax. +34 (93) 580 56 60</FONT> <BR><FONT = face=3DVerdana=20

    size=3D2>&nbsp;</FONT> </P><BR></SPAN></FONT></DIV>     <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">       <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20

      size=3D2>-----Mensaje original-----<BR><B>De:</B> Sonja =A9ehovic =

      [mailto:sonja.sehovic_at_zg.tel.hr]<BR><B>Enviado el:</B> jueves 2 = de=20

      noviembre de 2000 9:41<BR><B>Para:</B> Multiple recipients of = list=20

      ORACLE-L<BR><B>Asunto:</B> password for = internal<BR><BR></DIV></FONT>

      <DIV><FONT face=3DArial size=3D2>Hi listers!</FONT></DIV>
      <DIV><FONT face=3D"Arial CE" size=3D2>I want to put a password on =
INTERNAL. I=20
      tried with ORAPWD but it didn't work. </FONT></DIV>
      <DIV><FONT face=3D"Arial CE" size=3D2>It is Oracle 8.1.5 on =
AIX.</FONT></DIV>
      <DIV><FONT face=3D"Arial CE" size=3D2>Any ideas, =
suggestions?</FONT></DIV>
      <DIV><FONT face=3D"Arial CE" size=3D2>Thanks,</FONT></DIV>
Received on Thu Nov 02 2000 - 06:29:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US