| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: password for internal
grant sysdba to scott;
alter user scott identified by lion;
connect scott/lion as sysdba;
-----Original Message-----
From: Sonja =A9ehovic [mailto:sonja.sehovic_at_zg.tel.hr]
Sent: Thursday, November 02, 2000 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: password for internal
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.
=20
Sonja
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
---------------------------------------=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 (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. =20
Thanks for the tip. I'll try to run the script you mentioned.
=20
Sonja
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
---------------------------------------=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 (c)ehovic [mailto:sonja.sehovic_at_zg.tel.hr]
Received on Thu Nov 02 2000 - 09:10:25 CST
 |
 |