Re: password for internal

From: William Beilstein <BeilstWH_at_OBG.com>
Date: Thu, 02 Nov 2000 10:34:37 -0500
Message-Id: <10668.120968@fatcity.com>

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

• 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_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 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_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.

Received on Thu Nov 02 2000 - 09:34:37 CST