| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: password for internal
This is a multi-part message in MIME format.
------=_NextPart_000_002D_01C044DF.71AD6A40 Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
As a metter of fact ALTER USER is not working, as I tried it earlier =
(one of the first things)!=20
It replies with error:
ORA-01918 user 'INTERNAL' does not exist.
Sonja
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
---------------------------------------=20Javier Morales - javier_at_infojobs.net=20 Administraci=F3n Bases de Datos Oracle - InfoJobs.net=20 Tel. +34 902 10 60 90 Ext. 2067=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.
Sonja
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
------=_NextPart_000_002D_01C044DF.71AD6A40 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 content=3D"text/html; charset=3Diso-8859-2" =http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>As a metter of fact ALTER USER is not =working, as I=20
<DIV> </DIV> <DIV><FONT face=3D"Arial CE" size=3D2>Sonja</FONT></DIV> <BLOCKQUOTE=20
size=3D2> ---------------------------------------</FONT> =<BR><FONT=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. = </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> </DIV>
<DIV><FONT face=3D"Arial CE" size=3D2>Sonja</FONT></DIV>
<BLOCKQUOTE=20
<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=20
10:51 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> </DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D245552409-02112000>You mustn't allow connections in the =
host (in=20
UNIX, you can control the access to Oracle user...) but if you =
can't, you=20
would probably will have to enable password policies running the=20
script </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D245552409-02112000></SPAN></FONT> </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> </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=20
to 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> </DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D245552409-02112000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D245552409-02112000></SPAN></FONT> </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> </DIV>
<DIV><FONT color=3D#0000ff face=3DVerdana size=3D2><SPAN=20
class=3D245552409-02112000>
<P><FONT face=3DVerdana=20
size=3D2> ---------------------------------------</FONT> =
<BR><FONT=20
face=3DVerdana size=3D2> Javier Morales -=20
javier_at_infojobs.net</FONT> <BR><FONT face=3DVerdana=20
size=3D2> Administraci=F3n Bases de Datos Oracle - =
InfoJobs.net</FONT>=20
<BR><FONT face=3DVerdana size=3D2> Tel. +34 </FONT> =
<FONT=20
face=3DVerdana size=3D2>902 10 60 90</FONT><FONT face=3DVerdana =
size=3D2> =20
Ext. 2067</FONT> <BR><FONT face=3DVerdana size=3D2> Fax. +34 =
(93) 580 56=20
60</FONT> <BR><FONT face=3DVerdana size=3D2> </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=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.=20
I 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=20
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 - 08:13:24 CST
 |
 |