Re: The last date/time of changing password??

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 20 Jan 1999 16:57:43 +0800
Message-ID: <36A59A87.4DEE@bhp.com.au>

Donald Yeh wrote:
>
> A user can change his password using 'ALTER USER ......'.
>
> How can I get the last date/time of changing password?
> Which data dictionary store the infomation?
>
> ~Thanks.......
>
> ---------------------------------------------------------------
>
> Name: u7844131.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Donald Yeh

I don't think it is stored...

For password expiry (in Oracle 8 - it aint there in 7), all the database needs to know if when you password will expire (cf: EXPIRE_DATA in DBA_USERS)... Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Wed Jan 20 1999 - 02:57:43 CST