| 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
All users will be under the DEFAULT profile... so you can manage it as =
one
other profile...
The sintax of profiles is really simple...
CREATE PROFILE my_profile LIMIT
failed_login_attemps [n]
password_life_time [n]
password_reuse_max [n]
idle_time [n (...in minutes) ]=20
...
;
The same way for ALTER PROFILE, DROP, etc...
And then alter the user to specify the profile you chosed...
You don't have to shutdown your database, you just launch that script =
and
verify that you will turn the parameter RESOURCE_LIMIT =3D true;
ALTER SYSTEM SET RESOURCE_LIMIT=3Dtrue
I hope this would help... try to "limit" the DEFAULT profile and it =
will be
for all users...
... but take care... there will no longer exist the tipical
user=3Dpassword... you know what I mean... Oracle wouldn't let users =
have
passwords the same as their username...
-----Mensaje original-----
De: Sonja =A9ehovic [mailto:sonja.sehovic_at_zg.tel.hr]
Enviado el: viernes 3 de noviembre de 2000 13:06
Para: Multiple recipients of list ORACLE-L
Asunto: Re: password for internal
Sorry, I didn't reply sooner.
I have other problems which require my immediate attention.
I do have REMOTE_LOGIN_PASSWORDFILE =3DTRUE
Do I have to shutdown database to run that script (usually not)? Small
problem is that I can't shutdown my database now ;users are connected =
(how
dare they). As soon as I try I'll tell you. Does this script enable =
profile
limits for me or I have to do it manualy through user profiles?
Thanks for your help.
Sonja
> Let's take a look at the situation...
>
> are you sure that you have the parameter REMOTE_LOGIN_PASSWORDFILE =
to
> TRUE...?
>
> hmmmm...
>
> so, if you did, and you still connecting as internal in root, and
> servermanager doesn't ask you for the password, just think that the =
inner
> password for internal is the one you wrote in the password file, and =
I
think
> that you can make servermanager ask you for the password if you =
enable
> resource profile limits...
>
> ... did you tried to launch the script I told you...??
> ... did it work ?
>
>
> Getting desperate,
> Javier ;-)
>
>
> ---------------------------------------
> Javier Morales - javier_at_infojobs.net
> Administraci=F3n Bases de Datos Oracle - InfoJobs.net
> Tel. +34 902 10 60 90 Ext. 2067
> Fax. +34 (93) 580 56 60
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Javier Morales
> INET: Javier_at_infojobs.net
>
> 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
> also send the HELP command for other information (like subscribing).
>
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: =3D?iso-8859-2?Q?Sonja_=3DA9ehovi=3DE6?=3D
INET: sonja.sehovic_at_zg.tel.hr
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 - 08:56:55 CST
 |
 |