Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 administra=
tive 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 =A9ehovi (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)!=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]=20
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/Received on Thu Nov 02 2000 - 09:34:37 CST
=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]=20 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.
![]() |
![]() |