Re: determine when password will expire

On 17 Apr 2007 19:27:25 -0700, wagen123_at_yahoo.com wrote:

>Hi,
>
>Oracle10g R2
>RHEL 4.2
>
>I set the PASSWORD_LIFE_TIME value by modifying the profile.
>
>Is there a way to determine when a password will expire by querying
>internal tables/views, etc?
>
>Does anyone have details of the sys.users$ table - what do the columns
>indicate?
>
>Thanks for any help/pointers.
>wagen

1 this is maintained in dba_users
2 You shouldn't directly refer to the user$ table, as Oracle doesn't guarantee it's persistence over releases. The views will remain the same.
All data dictionary views are described in the DICT view, and the DICT_COLUMNS view and the DICT_COMMENTS view. They are also documented in the Oracle reference manual. If you really want to have a stab at it (which I don't recommend) you should read CATALOG.SQL.

-- 
Sybrand Bakker
Senior Oracle DBA