Re: determine when password will expire

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 18 Apr 2007 09:06:01 -0500
Message-ID: <4626197a$0$16373$88260bb3@free.teranews.com>

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
>

Look at the EXPIRY_DATE in DBA_USERS.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Wed Apr 18 2007 - 09:06:01 CDT