Re: Reseting after the first login

On 19 Sep 2006 12:10:50 -0700, "fitzjarrell_at_cox.net" <fitzjarrell_at_cox.net> wrote:

>You cannot. You CAN create a user with an expired password, however,
>even in 10gR2, the user cannot reset his/her own password:

 [snip examples using SQL*Plus]

>SQL> connect blabbo
>Enter password:
>ERROR:
>ORA-00604: error occurred at recursive SQL level 1
>ORA-06502: PL/SQL: numeric or value error
>ORA-06512: at line 14
>ORA-28001: the password has expired

 It's a bit odd that you're getting recursive SQL errors. I get the following behaviour - note that the password expiry is a top-level error, not lower within an error stack as in your demo:

[oracle_at_testbox ~]$ sys

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Sep 19 21:05:26 2006

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> alter user test password expire;

User altered.

SQL> connect test/test
ERROR:
ORA-28001: the password has expired

Changing password for test
New password:
Retype new password:
Password changed
Connected.
SQL>

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool