Very Computer

by **Bob Wile** » Wed, 02 May 2001 08:27:28

Hi,

What is the best command that would force a new user to change his/her
password after the first log in?

Thanks

by **Howard J. Roger** » Wed, 02 May 2001 14:10:29

Alter user blah password expire

BUT... all that does is set up an error condition (the condition being that
the password has expired). It's up to the application to trap that error
and prompt for a change of password. Sql*Plus, for example, *can* trap the
error and respond appropriately. Server Manager can't, and will simply tell
the user to 'bog off, your password's expired' (or words to that effect).

Regards
HJR

Quote:> Hi,

> What is the best command that would force a new user to change his/her
> password after the first log in?

> Thanks

by **Steve Lon** » Wed, 02 May 2001 16:23:29

that would depend on which version of oracle is in use. in 8.1.7, one can
set a number of options for user management similar to what one would do at
the OS level, whichi includes password expiration. if i recall correctly,
the section on "user management" in the DBA guide discusses the options
available.

prior to 8i, one has to write code to do the same thing, or use OS features.

Quote:> Hi,

> What is the best command that would force a new user to change his/her
> password after the first log in?

> Thanks

Very Computer

Change Password on first Log-in

Change Password on first Log-in

Change Password on first Log-in

Change Password on first Log-in