Message-Id: <10668.120956@fatcity.com> From: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= Date: Thu, 2 Nov 2000 15:13:24 +0100 Subject: 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 ----- Original Message -----=20 From: Javier Morales=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, November 02, 2000 1:40 PM Subject: RE: password for internal 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@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@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 ----- Original Message -----=20 From: Javier Morales=20 To: Multiple recipients of list ORACLE-L=20 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@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@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

As a metter of fact ALTER USER is not = working, as I=20 tried it earlier (one of the first things)!

It replies with error:

ORA-01918 user 'INTERNAL' does = not=20 exist.

Sonja

----- Original Message -----

From:=20 Javier=20 Morales

To: Multiple recipients of list ORACLE-L =

Sent: Thursday, November 02, = 2000 1:40=20 PM

Subject: RE: password for = internal

internal allways have a password = that's =20 ORACLE

if=20 you connect to oracle in the host machine, server manager doesn't ask = for=20 password...

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

I=20 hope this would help.

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

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

Initialy, I don't have = password for=20 INTERNAL, but for the security reasons I want to put it. =

Thanks for the tip. I'll try = to run the=20 script you mentioned.

Sonja

----- Original Message ----- =
From:=20 Javier=20 Morales
To: Multiple=20 recipients of list ORACLE-L

Sent: Thursday, November = 02, 2000=20 10:51 AM

Subject: RE: password for=20 internal

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.

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

utlpwdmg.sql

in the folder = rdbms/admin/

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

Hope this would = help...

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

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

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

Hi listers!

I want to put a password = on INTERNAL.=20 I tried with ORAPWD but it didn't work.

It is Oracle 8.1.5 on=20 AIX.

Any ideas, = suggestions?

Thanks,