Re: password for internal

Thanks for the explanation of INTERNAL . My problem is that I want to put password for INTERNAL which I don't have. I tried to this with changing with ORAPWD utility but nothin happened!

Sonja

• Original Message ----- From: "William Beilstein" <BeilstWH_at_OBG.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, November 02, 2000 4:40 PM Subject: Re: password for internal

> The internal user is not an actual user. You are actually connecting as
the SYS user with sysdba privileges. The reason that the internal user is there is to allow the DBA to connect to the database and perform administrative duties. The ability to connect as internal is typically restricted to the account or group (usually DBA in Unix) that created the database. The actual password for the internal connection is stored encrypted in the oracle password file. If you change the password for the SYS user you must regenerate the password file. If you are connected on the server as the Oracle admin user and you still can't connect internal and the password file is correct, see the note 69642.1 on MetaLink which goes into all the various reasons that a connect internal might fail.
>
>
>
> >>> Sonja Šehovi (B* <sonja.sehovic_at_zg.tel.hr> 11/02/00 09:15AM >>>
> As a metter of fact ALTER USER is not working, as I tried it earlier (one
of the first things)!
> It replies with error:
> ORA-01918 user 'INTERNAL' does not exist.
>
> Sonja
> ----- Original Message -----
> From: Javier Morales
> To: Multiple recipients of list ORACLE-L
> 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...
>
> you also can change internal's password with ALTER USER internal
IDENTIFIED BY new_password.
>
> I hope this would help.
>
> ---------------------------------------
> Javier Morales - javier_at_infojobs.net
> Administración Bases de Datos Oracle - InfoJobs.net
> Tel. +34 902 10 60 90 Ext. 2067
> Fax. +34 (93) 580 56 60
>
>
>
>
> -----Mensaje original-----
> De: Sonja Šehovic [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.
> Thanks for the tip. I'll try to run the script you mentioned.
>
> Sonja
> ----- Original Message -----
> From: Javier Morales
> To: Multiple recipients of list ORACLE-L
> 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.
>
> 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
>
> utlpwdmg.sql
> in the folder rdbms/admin/
>
> then you would be able to set up resource limits to system
parameters, management password lifes, etc.
>
>
>
> Hope this would help...
> ... but the most important is not allowing connections to server
manager in host...
>
> ---------------------------------------
> Javier Morales - javier_at_infojobs.net
> Administración Bases de Datos Oracle - InfoJobs.net
> Tel. +34 902 10 60 90 Ext. 2067
> Fax. +34 (93) 580 56 60
>
>
>
>
> -----Mensaje original-----
> De: Sonja Šehovic [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.
> It is Oracle 8.1.5 on AIX.
> Any ideas, suggestions?
> Thanks,
> Sonja
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: William Beilstein
> INET: BeilstWH_at_OBG.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
Received on Fri Nov 03 2000 - 02:54:36 CST