Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: password for internal

Re: password for internal

From: Sonja Šehović <sonja.sehovic_at_zg.tel.hr>
Date: Fri, 3 Nov 2000 09:56:48 +0100
Message-Id: <10669.121032@fatcity.com>


Hvala
Sonja
----- Original Message -----
From: "Gogala, Mladen" <MGogala_at_oxhp.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, November 02, 2000 4:11 PM Subject: RE: password for internal

> grant sysdba to scott;
> alter user scott identified by lion;
> connect scott/lion as sysdba;
>
> -----Original Message-----
> Sent: Thursday, November 02, 2000 9:16 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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 -----
> To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L
> Sent: Thursday, November 02, 2000 1:40 PM
>
> 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 (c)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 -----
> To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L
> Sent: Thursday, November 02, 2000 10:51 AM
>
> 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 (c)ehovic [mailto:sonja.sehovic_at_zg.tel.hr]
> Enviado el: jueves 2 de noviembre de 2000 9:41
> Para: Multiple recipients of list
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.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:56:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US