FYI... Figured I'd also send an example: SQL> create user tim identified by tim; User created. SQL> grant connect to tim; Grant succeeded. SQL> alter user tim password expire; User altered. SQL> select username, password, account_status from dba_users where username = 'TIM'; USERNAME PASSWORD ACCOUNT_STATUS ------------------------------ ------------------------------ -------------------------------- TIM 61A453F4EB9040B4 EXPIRED SQL> alter user tim identified by values '61A453F4EB9040B4'; User altered. SQL> select username, password, account_status from dba_users where username = 'TIM'; USERNAME PASSWORD ACCOUNT_STATUS ------------------------------ ------------------------------ -------------------------------- TIM 61A453F4EB9040B4 OPEN SQL> Tim Johnston wrote: >Guess what? The alter user trick works! At least it does on 8.1.7.4 and >9.2.0.3... > >Good call Paul! > >Rich... Paul just provided the solution to you problem! > >I think you owe him a virtual beer! > >Tim > >Paul Drake wrote: > > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------