Re: Last time password was changed

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 25 Nov 2002 21:13:20 GMT
Message-ID: <3DE29267.D86C0219@exesolutions.com>

Daniel Roy wrote:

> Hi everyone,
> is there anyone who would know where in the data dictionary is the
> last password change date stored for each user? My manager wants to
> know the users who have not changed their passwords in a long time.
> Running Oracle 8.1.6 (EE). In case it's relevant, there is no password
> policy implemented in the user profiles.
>
> Thanx
>
> Daniel

Look in the data dictionary table user$.

But it makes little sense to find out when they were done. Modify the default profile to force changes and control password reuse.

Daniel Morgan Received on Mon Nov 25 2002 - 15:13:20 CST