Re: Did you ever have one of those days?

From: Tim Johnston <tjohnston_at_quallaby.com>
Date: Thu, 20 May 2004 19:27:24 -0400
Message-ID: <40AD3EDC.6060105@quallaby.com>

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 20 2004 - 18:23:58 CDT